Fairly basic use of IF/THEN & OR

Follow

Yacine Ghalim

• August 11, 2015 14:55

Hi everyone,

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?

Many thanks!

0

• 

  Rainer Grabowski

  • August 11, 2015 15:13

  Hi Yacine,

  try this:

  @status == "rejected" || @status == "monitor" ? "OK" : "TBD"

  This works if status is a single choice category field

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.