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)
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…
