Help IF/AND formula with RYG conditional formatting

Adrienne Buesa

How do you create RYG symbol formula that requires multiple conditions of multiple reference cells?

Here are the conditions I'm trying to write a RYG formula for....using reference cells [LEADER NAME] and [RISK FLAG]:

If [LEADER NAME] = BLANK, then keep cell empty

If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = CHECKED, then “Red”

If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = UNCHECKED, then “Green”

Advice on how to write this formula? Seems like an IF + AND statement?

Find more posts tagged with

Formulas

functionality

Conditional Formatting

Cell linking

Accepted answers

Paul Newcome

Try something like this...

=IF([LEADER NAME]@row = "", "", IF([RISK FLAG]@row = 1, "Red", "Green"))

EDIT: Corrected a typo in formula.

All comments

Paul Newcome

Try something like this...

=IF([LEADER NAME]@row = "", "", IF([RISK FLAG]@row = 1, "Red", "Green"))

EDIT: Corrected a typo in formula.

Adrienne Buesa

Thank you this worked perfectly!

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.