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

edited 12/09/19 in Archived 2017 Posts

I would like to create an alert.  If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet.  Do not see how to establish an alert just based on change of color.


  • Shaine Greenwood

    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.