automation with clock timer
Hello ,
Date column is not enough for automation updates/approvals and reminders , we need to send it conditioned on time formula ( clock ) .
For example like to insert task time and and to create automated reminder / update or approval request that with condition based on time , like if the time is 1,2, 3 hours is less thatn to send the auto request etc
It seems like there is no way to do it and the automation is either hourly or daily not specific time , please let me know how to do it even if to go with 3rd party integration
Thank you
Answers
-
I am not sure about 3rd party integrations, but you could pull the hour from your time input into a separate hidden column and then setup your automations to run based on that.
So basically you would have up to 24 automations. You would set one (for example) to run at 1pm and have it based on rows where the hidden column is "13" (1pm in 24 hour time). Set up the same thing to run at noon based on rows that have a "12". So on and so forth.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks Paul ,
But how can i put or track my real time into a column ?
Im asking about real time that count around the clock not time added in down list :(
So for example to set auto action ( update / approval or reminder etc ) to be sent when actual time is reached automatically
-
That is not an option within Smartsheet unless you wanted to use a 3rd party app such as Zapier to send an update to a sheet more frequently than hourly. Then you would still need to set up separate automations for each specific time after pulling the time into a different cell in text format.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you @Paul Newcome ,
We need to have this feature , time column with hourly automation function
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!