Time Column Format

cthrasher97141 · 02/07/20

Is there a column type in Smartsheet to allow a user to select a time , ie 12:45 PM or 5:15 AM, in Smartsheet?

Andrée Starå · 02/07/20

Hi,

Unfortunately, there isn't at the moment, but Smartsheet is working on it.

Please submit an Enhancement Request when you have a moment to have your vote added

There are workarounds, but they are fairly advanced.

How would you like to use it?

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

cthrasher97141 · 02/10/20

Thank you Andree!

I am using the time field so a user can input a time that an activity happened because they may not be filling out a form the same time an activity happened. I then want to use the time and the activity type to do a scatter/plot type graph for forecasting. I haven't tackled the graph yet since Smartsheet doesn't have that type of graph. If you have any suggestions on that I would love to hear them!

Thank you again for the response!

Adam Horak · 02/13/20

When do you think this functionality will be available? In my case it is very important. I am surprised by the lack of such a column that it seems that it should be basic.

Andrée Starå · 02/27/20

@cthrasher97141,

Happy to help!

I'll get back to you if I come to think of something!

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 02/27/20

Hi @Adam Horak,

Unfortunately, I don't know when it will be released. Hopefully soon!

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

KentB · 01/12/23

It's hard to imagine a spreadsheet designed to track progress and task management does not yet incorporate a column for time. Is there a "time" frame we might be expecting this function? Trying to work a "time" column or similar "due by" function. Need to be able to have time of day. Anyone have a work around to the current lack of a time option?

Kentb

Chigginbotham · 03/14/23

I'm finding a lot of needed features that were requested years ago and they are always working on it. I love the program but there are lots of needed enhancements.

eAnge · 05/08/23

To date; this simple function is not available. We are paying $$$on subscription for incomplete functions.

Gavin Seaton · 05/25/23

Any update on this from Smartsheet?

Really frustrating they havent released anything on this despite saying it was 'Hopefully Soon' way back in 2020.

This feature would make Smartsheet much more versatile

Jbob · 11/08/23

Any update on this from Smartsheet?

Really frustrating they havent released anything on this despite saying it was 'Hopefully Soon' way back in 2020.

This feature would make Smartsheet much more versatile

Smartsheet Basics

Smartsheet Basics

Time Column Format

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Has anyone tried to create a trivia game using Smartsheet?

What's the maximum number of rows in a sheet ? Is there any limitation on the number of columns ?

Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator