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)
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
