Can time be automated by hours in a Smartsheet column?

Smartadmin2

Hello, for a few days I have been trying to automate time, not by days (because in smartsheet automations time is automated in days when recording a date) but in hours, so that through automation or a formula, a time can be recorded when a cell is modified, and at the same time those hours can be operated on, adding or subtracting hours, I would like to know if that is possible? If there is a formula or method to be able to record hours in columns and at the same time perform operations with them.

Melissa Yamada

@Smartadmin2 you can try checking this community thread that might help you on the solution you need utilizing the Modified Date system column.

Is there a way to timestamp using a formula?

AimeeRH

Sep 26, 2023

Apologies if this has been asked previously, I am wondering if there is a formula (or any other method) that can be used that can add a timestamp into a cell for when the workflow was triggered.

For example, I have a workflow that sends an email to person 1 and i would like the date and time in a cell that this was sent to person 1

Thank you in advance! 😊

---

View Post