Conditional Formatting: Date Ranges

Hello everyone!

I currently have a column called Days Open that uses a formula to calculate the amount of time a request has been open. I have also created a column next to it, where I have created dropdown SLA ranges (i.e. 30 Days, 30-60 Days, 60-90 Days). Is there conditional formatting that I can use to have Smartsheet automatically place the request into an SLA range based on the number of Days Open?

Ex: A request shows 32 under Days Open. I would like the sheet to automatically select the appropriate SLA range based on the number shown in the Days Open column (32). The range selected should be: 30-60 Days.

Answers