RYG Formula for Date Started

Hey all. Very new to any type of formula composition. This is likely very basic for some.

We have a "Date Started" column and "Date Completed" Column. Essentially I would like to set up a Red, Yellow, Green Status column tracking each project.

My guidelines would be "Green" if date completed has a date.

"Yellow" If between today and 6 days since "Date Received"

"Red" If greater than or equal to 7 days since "Date Received"

Any insight? Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @AlexGee Atlantic

=IF(ISDATE([Date Completed]@row), "Green", IF(AND([Date Received]@row=TODAY(), [Date Received]@row>=TODAY(-6)), 'Yellow", IF([Date Received]@row<=TODAY(-7),"Red")))

Will this work for you?

Kelly

AlexGee Atlantic

https://community.smartsheet.com/discussion/comment/339834#Comment_339834

HI Kelly!

This gave me "#UNPARSEABLE"

Kelly Moore

Hey

Sorry for the typo. There is an apostrophe in front of Yellow instead of the quote.

=IF(ISDATE([Date Completed]@row), "Green", IF(AND([Date Received]@row=TODAY(), [Date Received]@row>=TODAY(-6)), "Yellow", IF([Date Received]@row<=TODAY(-7),"Red")))

try now

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.