Formatting with alerts

kellyhatcher

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.

Mike Wilday

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.

 

kellyhatcher

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.