Is there any formula to capture the current/real time in smartsheets?
I want to set up an automation on a sheet where, if a form is submitted/received, within an exact 48-hour time frame I can trigger the mail. From created date column, I can get the time on when the row is created. But I'm not sure about how to accurately track the passage of 48 hours in order to send the email notification.
Is there any way to capture the current/real-time, which I can then subtract the "Created On" time and the trigger the email based on that?
Can someone help. Any other ideas/workarounds would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!