Displaying Date AND Time

Bob White

Is there a way to display a date and time within a data field.  I'm using Smartsheet to track the processing of incoming reports.  Employees log when they assign the report to themselves and when they've completed it. 

 

I have the From and To dates, but would like to get this down to Hours since reports are mostly completed within a few hours.  Is there a way to display this?

 

 

Andrée Starå

Hi Bob,

Yes, but it can be quite complicated to set up.

Will anything on the row change after they've marked that the report is completed?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Ezra

It would be great to have HH:MM:SS format built into Smartsheet..  It's something many have apparently been asking to be included for quite some time.

I've yet to build the resourcing into a proper form, but if you look into resourcing, tasks can be set with the d and h shorthand: "1d" for one day or "2.25h" for two hours and fifteen minutes.

Here's some of the quick and dirty work I've done on time tracking:

https://app.smartsheet.com/b/publish?EQBCT=90d9dcad6ed246a89a1dbe6cfdce315d

Another version:

https://app.smartsheet.com/b/publish?EQBCT=698fa97db2e848acbba1db03ca04667b