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

Find more posts tagged with

Accepted answers

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.