Time Function

Jae Anderson

Imported an Excel sheet that calculates end times for tasks as a start for a Smartsheet.  The intent is that we give a start time for the day, number of appointments needed and it builds a schedule, which I can then link with other Smartsheets.  

 

It seems the Time Function is not supported.  Does anyone know if this is coming, or maybe if there is a workaround?

Travis

Scheduling tasks for specific times is not supported right now, but you can track this is a Text/Number column. We are tracking feedback for this request and I will add your vote for it! 

Joel Bordewyk

Please add my vote also!  I am very very interested in utilizing a time function, and working to get our 26 sister facilities to utilize SmartSheet for shutdown planning.

Mariana

Hi, I'm not sure if this fully answers your question, but it may help you with time tracking. We are currently using TrackingTime with Smartsheet. It takes only one formula and you can get timesheets and reports out of your data automatically. 

Here's the link https://trackingtime.co/time-tracking-for-smartsheet

 

Hope you find it useful.

Cheers.

Mariana