Date & Time

Marilen.Navarro103391

Hello-

How do I add the date and time from start of task to end of task from this form?

I need to measure the date and time from start to finish. I'm using the FORM. Thanks.

Genevieve P.

Hi @Marilen.Navarro103391

You can add Date columns in your sheet that can then be surfaced in a Form, however Smartsheet does not have a specific Time column or time functionality.

You may want to check out Paul's post that goes through different formula combinations to calculate time:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

You could add Text/Number columns to your sheet to ask the user to record time in a specific format that would work with the formulas above.

Cheers,

Genevieve

Genevieve P.

Hi @Marilen.Navarro103391

You can add Date columns in your sheet that can then be surfaced in a Form, however Smartsheet does not have a specific Time column or time functionality.

You may want to check out Paul's post that goes through different formula combinations to calculate time:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

You could add Text/Number columns to your sheet to ask the user to record time in a specific format that would work with the formulas above.

Cheers,

Genevieve

Raptor

When will the time column be available in SmartSheets?

Alan Meshaw

see this post: https://www.google.com/search?q=smartshhet+record+time+row+changed&rlz=1C1GCEA_enUS824US824&oq=smartshhet+record+time+row+changed&gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIICAEQABgWGB4yDQgCEAAYhgMYgAQYigUyDQgDEAAYhgMYgAQYigUyDQgEEAAYhgMYgAQYigUyCggFEAAYgAQYogQyCggGEAAYgAQYogQyCggHEAAYgAQYogQyCggIEAAYgAQYogQyCggJEAAYgAQYogTSAQg2NTYwajBqNKgCALACAQ&sourceid=chrome&ie=UTF-8#fpstate=ive&vld=cid:15c0b832,vid:J2jrhCfsDy0,st:36

Samantha Matraiotti

Will the date/time column type ever be fixed to include the time? At the moment it is date only. This is one area where Smartsheet falls short of MS Project for managing projects.

Ramsey A

First, create a 'Created Date' column. Then, create a 'Number/Text' column and use the following formula to extract the time:

="" + RIGHT([Created Date]@row, 8)

This formula will extract the time portion from the 'Created Date' column."

Hope this helps.