Sign in to join the conversation:
I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not there?
Hi Tash,
Unfortunately, Smartsheet doesn't have a Time specific column just yet, but it's coming.
A workaround could be to use a dropdown list, and it's also possible to set up a solution where you can select the start time and end time to calculate the total time.
Another option could be a time measuring add-ons/plugin that you can use together with Google Chrome.
Can you describe your process in more detail so that I can maybe give you a better recommendation?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Is this still not an option?
Hi @ErinMay
I hope you're well and safe!
Unfortunately, it's not released yet, but hopefully, it will be released soon.
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Be safe and have a fantastic weekend!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
I had to add a lot of helper columns to make a workaround. My first column is the start timestamp. My next 3 helper columns break down the hour and minutes then convert them to decimal. I do the same thing with my end timestamp. Then I do the calculation. I also have to reconvert it to minutes for another project. Seems like a lot of work, but once it's done, it's done. It's definitely ugly, but it does the trick until SmartSheet can figure out how to make it a standard function. Hope it helps.
TimeStart Start Hour Start Min Start Convert
13:18 13 18 13.30
Start Hour =LEFT(TimeStart@row, 2)
Start Min =RIGHT(TimeStart@row, 2)
Start Convert =VALUE([Start Hour]@row) + (VALUE([Start Min]@row) / 60)
TimeEnd End Hour End Min End Convert
14:38 14 38 14.63
End Hour =LEFT(TimeEnd@row, 2)
End Min =RIGHT(TimeEnd@row, 2)
End Convert =VALUE([End Hour]@row) + (VALUE([End Min]@row) / 60)
Resp Time Resp Mins
1.33 80
Resp Time =IF([End Convert]@row >= [Start Convert]@row, [End Convert]@row - [Start Convert]@row, [End Convert]@row + 24 - [Start Convert]@row)
Resp Mins =IF([Resp Time]@row > -1, [Resp Time]@row * 60, [Resp Time]@row + 1440)
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
I have an automation setup to escalate to managers when a step goes beyond 2 days. I have that titled as Escalation for Purchasing, Escalation for Planning, etc. In my trial run, 3 out of 6 showed up as Reminder: New part number request log ( this is the name of the sheet) The only thing we could see was that the ones that…
