Formula based on System-Generated Created Time
Is there are formula to bring the time out of the the System-Generated Created Time to e.g. add on 20 min to this and then perform an action?
I have an easy sheet which is filled via 2 forms; one form is used to check in, one is for the check out, filling the same sheet.
Problem statement: If someone forgot to check out, we want to have an automation after 20 min, that this checked in person is automatically checked out or alternatively gets an email that he/she has to check out.
I researched a lot here in the help articles but did not find much for now, any help is appreciated!
Thanks!
Best Answer
-
No, you cannot check current time directly with a formula inside of smartsheet. If you want to add 20 minutes to the time that is possible through text parsing, but the alert can't be set up through standard smartsheet functionality.
That said this could be completed through the API, but it would require coding.
Answers
-
No, you cannot check current time directly with a formula inside of smartsheet. If you want to add 20 minutes to the time that is possible through text parsing, but the alert can't be set up through standard smartsheet functionality.
That said this could be completed through the API, but it would require coding.
-
Hi, thanks a lot for the fast reply. I already assumed that it will not work but wanted a verification. Unfortunately coding is not an option. But thanks again, I will tell the owners that they have to monitor their sheet manually and check out people directly there if they do not check out themselves.
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!