RYG Formula for Date Started

AlexGee Atlantic · 08/15/22

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

Kelly Moore · 08/16/22

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 · 08/16/22

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

HI Kelly!

This gave me "#UNPARSEABLE"

Kelly Moore · 08/16/22

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

RYG Formula for Date Started

Answers

Help Article Resources

Categories