Automating a push notification based on a cell value
I have an automation process where I need to push a notification based on a specific time value within a cell.
So the data's coming in from a form with the date and the hour a phone call needs to be made. I.E 14:00.
When 14:00 rolls around I want to push a notification to someone listed in a contact cell.
Any ideas on how I can do this?
Answers
-
Hi @Frank99
Smartsheet does not currently have Time functionality or columns in the sheet. However there is the ability to set Time and Date based automations on the hour. See: Create a Time-Based Automated Workflow
You would need to create one Workflow per hour that could be selected.
Let me know if this will work for you!
Cheers,
Genevieve
-
Hi Genevieve, thank you for the response, that will hopefully do the trick in this case.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives