Including NOT(ISBLANK(... In Formula

Taylor Compton - NOAA Federal

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")))

Paul Newcome

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

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")

Taylor Compton - NOAA Federal

@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!

Paul Newcome

Happy to help. 👍️