Conditional alert and reminder
Hi
I'm new in Smartsheet.
I have a goal which is to set an automated alert like "If any change is made in specific column(s) by any editor after the date specified in Alert Date column, send an alert to the Admin."
Is it possible to combine this many conditions?
If it's not possible, how about setting a conditional reminder like "On the date specified in Reminder Date column, send a reminder to the admin to set an automated alert."?
Thank you.
Comments
-
Its possible to set that condition. Here are the settings you should use.
- Click the Alerts and Actions tab
- Choose Send a Notification > When a row is updated, added, etc.
- Click the checkbox next to updated, uncheck other boxes.
- Click the Add a condition check box.
- Click When Alert Date Column is in the past.
- Choose who the alert should be delivered to and save
You can also click on delivery settings and add a custom message and subject line.
See the screenshot below for visual example.
-
Wow, thank you!
This is exactly what I wanted to do.
-
You're welcome. Glad I could help out.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives