Help turning tasks yellow less than 30 days till finish

Paul Whelan

I have the R/G ok, blue for complete, but I cant seem to get it yellow if the finish date is less than 30 days away:

=IF(Status@row = "complete", "Blue", IF(Finish@row < TODAY(), "Red", IF(Status@row = "In Progress", "Green")))

Find more posts tagged with

Formulas

Accepted answers

All comments

Sam_Harwart

Hi @Paul Whelan !

I don't see anything in the formula for Yellow. It also seems like you're using a mix of status and date values - you'll need to think through the precedence of these assignments.

Blue = status = complete

Red = finish < today [aka behind assigned date]

Yellow = finish - today < 30

Green = in progress [anything left over]

Try something like this:

=IF([Status3]@row = "Complete", "Blue", IF([Finish Date]@row < TODAY(), "Red", IF([Finish Date]@row - TODAY() < 30, "Yellow", "Green")))

Paul Whelan

=IF(Status@row = "Complete", "Blue", IF(Finish@row < TODAY(), "Red", IF(Finish@row - TODAY() < 30, "Yellow", "Green")))

Perfect :) Thank you.

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.