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

Options
kellyhatcher
edited 12/09/19 in Archived 2017 Posts

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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.

     

    conditionalformatting.jpg

  • kellyhatcher
    Options

    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.

This discussion has been closed.