How do I get a cell to change color based at certain increments based off of a date in a column?
I want to be able to change the color of date cells in a Smartsheet at 5 years and 9 years out from the install date in each row of a column.
One the 5 year mark is reached after install - it changes the cell to yellow, and at 9 years it turns that cell to red once the 9 year mark is reached
Not even sure where to start with this one - hopefully someone can help/advise.
Help Article Resources
Check out the Formula Handbook template!