Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional Formatting For 11 Months From a Date
Thanks in advance for the help. Here is what I'm trying to accomplish. A service is sold on a specific date. We want a "timer" to start that will highlight the row yellow when it's 2 months from expiring. We want to highlight any row within the 10 month window from start date to be green & dates beyond 365 days to turn red. It would also be nice when we input a date in "Date In Service" column to then automatically populate a date 12 months from then in Tune-Up column.
Any thoughts on how to make this happen?