Red, Yellow, Green multiple columns

Hello,

I'm trying to create a formula that will put out a color according to multiple colors in a column. For example: there are columns 1 thru 6 that are rated red, yellow or green. In column 7, if any are yellow, it will output a yellow and if any are red, will output a red dot; if all are green, will output a green dot. I know how to do it for yellow and green, not sure how to add red to the equation. This is what I have so far:

=IF(OR([Column1]@row = "Yellow", [Column2]@row = "Yellow", [Column3]@row = "Yellow", [Column4]@row = "Yellow", [Column5]@row = "Yellow", [Column6]@row = "Yellow"), "Yellow", "Green")

Find more posts tagged with

IF(OR

Accepted answers

heyjay

=IF(COUNTIF(A@row:C@row, "Red") > 0, "Red", 
IF(COUNTIF(A@row:C@row, "Yellow") > 0, "Yellow", 
"Green"))

Assuming that your status columns are side by side, replace A@row:C@row with the first and last column. eg Column1@row:Column6@row

All comments

heyjay

What if there is a RED and YELLOW, what should it output? What color is the priority?

Crysn

If there are any red, it will output a red dot. These are risk ratings. Green = no risk, yellow = medium risk, red = high risk.

heyjay

=IF(COUNTIF(A@row:C@row, "Red") > 0, "Red", 
IF(COUNTIF(A@row:C@row, "Yellow") > 0, "Yellow", 
"Green"))

Assuming that your status columns are side by side, replace A@row:C@row with the first and last column. eg Column1@row:Column6@row

Crysn

That worked, thank you! I was over complicating it.

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.