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.

Find more posts tagged with

Manufacturing

Formulas

Email Notifications

Comments

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.