Forum Discussion
jsaue003
7 years agoFrequent Visitor
AND IF in conditional column
Hello.
I have three columns with health values (Scope Health, Schedule Health, Budget Health) and four category columns which are supposed to be populated with Path to Green if any of the three columns with health values are other than green. I've tried a custom column with the following:
if [Scope Health] <> "Green" or [Schedule Health] <> "Green" or [Budget Health] <> "Green"
AND
[Category 1] <> "Path to Green" or [Category 2] <> "Path to Green" or [Category 3] <> "Path to Green"or [Category 4] <> "Path to Green"
THEN "Yes"
No matter what I swap around I can't get this to say "Yes" correctly. The function itself gives me errors (token THEN expected). How can I achieve this?
I believe you want this:
if ([Scope Health] <> "Green" or [Schedule Health] <> "Green" or [Budget Health] <> "Green") and [Category 1] <> "Path to Green" or [Category 2] <> "Path to Green" or [Category 3 <> "Path to Green" or [Category 4] <> "Path to Green" then "Yes" else "No"
1 Reply
- Greg_DecklerCommunity Champion
I believe you want this:
if ([Scope Health] <> "Green" or [Schedule Health] <> "Green" or [Budget Health] <> "Green") and [Category 1] <> "Path to Green" or [Category 2] <> "Path to Green" or [Category 3 <> "Path to Green" or [Category 4] <> "Path to Green" then "Yes" else "No"