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
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives