IF formula for RYG balls

Melissa Logan

Hi I am trying to make a formula that states:

If it is 14 days past the TBF date field, and the Reported date field is blank, make the ball Red.

If it is 7 days past the TBF date field, and the Reported date field is blank, make the ball Yellow.

If the Reported date field is NOT blank, make the ball Green.

Nothing I try seems to work - I'm not the best with If & Today statements, and I have a feeling I need both.

Find more posts tagged with

Formulas

functionality

Project Management

Accepted answers

Paul Newcome

Try something like this...

=IF([Reported Date]@row <> "", "Green", IF(TODAY() >= [TBF Date]@row + 14, "Red", IF(TODAY() >= [TBF Date]@row + 7, "Yellow")))

All comments

Paul Newcome

Try something like this...

=IF([Reported Date]@row <> "", "Green", IF(TODAY() >= [TBF Date]@row + 14, "Red", IF(TODAY() >= [TBF Date]@row + 7, "Yellow")))

Melissa Logan

that worked perfectly, thank you!

Paul Newcome

Happy to help! 👍️

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.