I need to trigger an update request 2 hours after the date time in a field - can anyone help?
I have a date time value in a field like this 11/04/202016:00
when it is 2 hours past this time I need to send out an update request.
Any ideas...I cannot find a way to do this.
thanks LuAnne Tiangco
Answers
-
Hello @LuAnne Tiangco ,
As of now, Smartsheet doesn't have a dedicated Time Feature, although I do love your idea!
Please feel free to raise an Enhancement Request here.
Although I'm unable to confirm it, this may be possible using a third party app such as Zapier.
Furthermore, you may wish to look at the different Time Formulas created here, to which you may be able to incorporate this into your current Sheet(s): https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time
Let me know if you have any questions!
Regards
Sean
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!