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.
Alerts/Notifications based on cell color
Options
Comments
-
Hi Kelly,
There currently isn't a way to create alerts based off of cell color changes.
With that in mind, it sounds like you might be using conditional formatting to have the red color applied to your cell automatically. I'd recommend that you try using the same criteria in your alert that you've set up in your conditional formatting rule.
For example, if your conditional formatting rule turns the cell red if the date is a certain amount of days from today's date, then create an alert that sends an email with that same criteria.
This discussion has been closed.