2

Hello

 

Does anyone know if there is a way to calculate Time in smartsheet without using a 3rd party program?

 

Thank you.

Functionality
Formulas
Sheets
Workspaces
Industry
Transportation

Comments

Hi there - 

We did release a TIME formula for certain users to test, but it didn't turn out to be what the majority of customers needed, so we have not yet enabled it for general availability.

The formula works well for a time tracking sort of sheet - to parse time out from 2 dropdown columns (for example, plain number/text values to select a predefined time of day for clocking in and clocking out), plus any lunch/breaks in between.

If this would be helpful to you, please send me an email at kara.lumley@smartsheet.com and I can enable it for you and send you an example sheet. I'd also be interested in hearing about your use case.

Best,

Kara

Hi Kara, 

Is this still an option on trial? I'd be interesting in trying this implementation if it's available.

Thanks

Matt