Forum Discussion

jsaue003's avatar
jsaue003
Frequent Visitor
7 years ago
Solved

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_Deckler's avatar
    Greg_Deckler
    Community 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"