Including NOT(ISBLANK(... In Formula
Hello,
I'm having difficulty including in a IF(OR formula that is looking for a not blank column. This column is intended to be a helper to build a report which incorporates both AND and OR statements. I'm trying to indicate a "green" status if any one of the variables are true, but I'm getting stuck on looking for a column to have any person; just not be blank.
=IF(OR([Org]@row = "HR", [Leader]@row = "PERSON", NOT(ISBLANK([HR Component]@row), "Green", "Gray")))
Best Answer
-
You just have some misplaced parenthesis to close out the NOT and OR functions before moving on to the rest of the IF statement.
=IF(OR([Org]@row = "HR", [Leader]@row = "PERSON", NOT(ISBLANK([HR Component]@row))), "Green", "Gray")
Answers
-
You just have some misplaced parenthesis to close out the NOT and OR functions before moving on to the rest of the IF statement.
=IF(OR([Org]@row = "HR", [Leader]@row = "PERSON", NOT(ISBLANK([HR Component]@row))), "Green", "Gray")
-
@Paul Newcome thanks for the fast reply and the correction worked. Must have tried adding different combinations of the parenthesis but the correct one. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!
