Traffic light formula

Hi,

I have a traffic light column in spreadsheet and I have a formula that triggers the colour based on a status column. I am just looking to add a step in that turns the traffic light red if it is not started or in progress and it is past the due date

Formula so far

=IF(Status210 = "Completed", "Green", IF(Status210 = "In progress", "Yellow", IF(Status210 = "Not Started", "Blue")))

Find more posts tagged with

Formulas

Accepted answers

All comments

12vanblart

I believe you would be looking for this:

=IF([Due Date]210 > TODAY(),"Red",IF(Status210 = "Completed","Green", IF(Status210 = "In progress","Yellow", "Blue"))

Note that I updated your equation so that it doesn't check for "Not Started" to return Blue so that Blue will show any time none of the other conditions are met.

You also may need to update the Due Date column name to match exactly what your column is named.

cashhaughey

I have corrected the formula…just for fun. You will need to change "210" for individual rows to compare values or a global reference if converted to a formula.

=IF([Due Date]210 > TODAY(),"Red", IF([Status]210 = "Completed", "Green", IF([Status]210 = "In progress", "Yellow", "Blue")))

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.