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
Answers
-
=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
-
HI Kelly!
This gave me "#UNPARSEABLE"
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!