Revise Formula - RYG

I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red")

However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.

Find more posts tagged with

Formulas

Accepted answers

Ryan Kramer

Give this a shot -

=IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", IF(CONTAINS("Specific Word", [Column 3]@row), "Yellow", "Red"))

All comments

Ryan Kramer

Give this a shot -

=IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", IF(CONTAINS("Specific Word", [Column 3]@row), "Yellow", "Red"))

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.