Archived 2017 Posts
Archived 2017 Posts
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives