In Smartsheet, we often need to determine how much time has passed since a project was opened to prioritize its completion based on the elapsed time. To do this, we need to calculate the difference between the current time and the project's creation time. It would be helpful to have a formula similar to NOW()
or CURRENT()
that provides the current time, as this feature is available in other spreadsheets and would allow us to calculate elapsed time more efficiently.
Estemum Kamal Lithia
Automation Analyst