Help with a Formula for Status Change

Armando D Garcia

I want to create a formula that changes the status colors to red, yellow or green. Below are the criteria:

IF Due Date is < Today and progress bar is not "Full", then "Red".

IF Due Date is > Today - 3days, and progress bar is not "Three Quarters", then "Yellow"

All other scenarios = "Green"

Any help or suggestions would be appreciated.

Thank you

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi@Armando D Garcia ,

Try:

=IF(AND([due date]@row<today(), [Progress bar]@row <>"Full"), "Red", IF(AND([due date]@row>today(-3), [Progress bar]@row<>"three quarters"), "yellow", "green")

Mark

All comments

Mark Cronk

Hi@Armando D Garcia ,

Try:

=IF(AND([due date]@row<today(), [Progress bar]@row <>"Full"), "Red", IF(AND([due date]@row>today(-3), [Progress bar]@row<>"three quarters"), "yellow", "green")

Mark

Armando D Garcia

Thanks, Mark. It worked! Your help and insight was very much appreciated.

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.