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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!