I have a field called Status that can take 5 different values: unqualified, qualified, in process, rejected, monitor.
I'm trying to create a calculation field called Dummy that would return "TBD" if Status is equal to unqualified or qualified or in process, and nothing (or "OK") in the other 2 cases.
It needs to be a calculation field (not a workflow) because I need to use this field in Globiflow at a later stage (has to be a calculation field).
How would you go about it?
Please sign in to leave a comment.