Help with IF(AND(ISBLANK statement

Hey there, looking for help with this formula:

=IF(AND(ISBLANK([Orientation Appointment]3)), [HR RedCarpet Green Light]3=0), "Red", "Green")

Trying to get it to read a Red ball if "Orientation Appointment" cell is blank AND if "HR RedCarpet Green Light" cell is not checked, but I seem to be doing something wrong.

Thanks!

Find more posts tagged with

Accepted answers

All comments

MCorbin

You have an extra close parentheses after the Orientation Appointment piece. Try this:

=IF(AND(ISBLANK([Orientation Appointment]3), [HR RedCarpet Green Light]3=0), "Red", "Green")

Christina Riley

AH! Those darn parenthesis get me every time. Thanks!

Christina Riley

Hmmm so the formula works but not the way I intend.

If "Orientation Appointment" is filled in but the HR RedCarpet Green Light is not checked, it's showing green. I need both those conditions to be true for it to be green, but it seems to only be applying the logic to one condition and not the other.

So BOTH the orientation needs to be filled in and the HR REdCarpet Green light checked for it to show green. What am I doing wrong?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.