Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started

M.Q.

Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started).

This is what I had:

=IF(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))

Find more posts tagged with

Sheets

Formulas

IT & Operations

Conditional Formatting

Accepted answers

Summer

Hi @M.Q.

Try it without the AND statement.

=IF(Status@row = "Not Started", "Red", IF(Status@row = "Completed", "Green", IF(Status@row = "In Progress", "Yellow", "")))

All comments

Summer

Hi @M.Q.

Try it without the AND statement.

=IF(Status@row = "Not Started", "Red", IF(Status@row = "Completed", "Green", IF(Status@row = "In Progress", "Yellow", "")))

M.Q.

That worked, Thanks @Summer!

I am also looking to do a average of the those children row on the parent row to automatically update the RYG. So if most of the health status are red in the children, then the parent will also be red.

TIA

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.