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.
Formatting with alerts
I need to do the combination of formatting with and alert, but seem to have hit a wall.
If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red and send an alert to the contact in columns "PM" and a particular individual.
Any help would be appreciated.
Comments
-
Conditional Formatting has to be set up separately from the alerts. You can use theΒ Formatting icon in the toolbar on the right to set up your conditions for formatting the row or cell.Β See screenshot below andΒ https://help.smartsheet.com/articles/516359-conditional-formatting for additional assistance.
Β
-
Let me separate it into two questions.Β Videos are worthless.
Formatting question: How do I accomplish below?
If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red.
Notification question:Β How do I accomplish below?
Send an alert to the contact in columns "PM" and a particular individual when a cell changes colors.
