I have a column (in a project report) that lists the current task(s). Thanks to @Doug Den Hoed‚, via WF-Pro for providing this in another thread.
This IF statement (by WF-Pro) accounts for a task that contains the "CPL" status.
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," "))))
We also sometimes use a custom status "Waived" with the "FLG" key.
So I tried this:
IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL"||"FLG",{status}),"",CONCAT({name}," "))))
after CPL, I put "OR "FLG". no luck.
So I tried this:
IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}||"FLG"{status}),"",CONCAT({name}," ")))). nope, not that either.
I even tried this:
IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("FLG",{status}),"",CONCAT({name}," ")))))). ugh, why can't I figure this out?
I also tried this format:
IF(Status="CPL"||Status="FLG", to no avail.
Can someone tell me how to put an OR modifier in a multi-IF statement?