How to have a Date and Time format for Date Column Properties?

Benjo09 · 05/28/20

Hi,

Do we have Date and Time format now for Date columns?

Andrée Starå · 05/28/20

Hi@Benjo09

Unfortunately, it's not possible at the moment because there isn't a time function/column, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

The System Columns, Created, and Modified have the time as well.

What's your use-case/process? There might be a possible workaround.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @WORK BOLD

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

Barry Bowles · 07/29/20

Hi @Andrée StaråI just discovered today thee is no time formatting or capability in Smartsheet like the basic functions in excel for handling time - I'm flabbergasted to discover that smartsheet does not have this ability and it imposes some real limitations on using smartsheet. Projects and workflow savings can only be measured in time and limiting that time to # of days stops smartsheet for being used for any time-critical activity.

例如我的用例是我处理a 3rd party who is supplying me with appointments (you already got it right?) and I import those appointments into smartsheet so I can allocate resources for each appointment (we usually allocated 2 people to each one) and then of course we want to look at the appointments in a calendar view and then record results of the appointment in smartsheet afterwards - much the same as you would use a CRM for sales calls. I cannot think of a work-around but am hoping that people who have been using smartsheet a long time may have come up with one until smartsheet decides to add it in as a "feature". Perhaps a formula that takes a 24 hr text representation of 13:30 (1:30pm) and converts it to a number so it can be used in calculations and converted back to a 24hr text representation. As you said Smartsheet uses time in a number of its system columns plus uses time in the comments column where time sensitivity is critical but fails to make it available in Date cells.

Hoping someone out there knows a workaround

regards

Barry

Andrée Starå · 08/01/20

Hi@Barry Bowles

It's coming, and hopefully, soon!

In the meanwhile, there are many different workarounds for time solutions.

I recently developed a client solution to measure time worked on different factory/manufacturing process stages.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or somescreenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

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

Andrée Starå · 08/01/20

@lewis hamilton

Your solution is for Excel and not Smartsheet so that it won't work, unfortunately.

SuzanneH · 10/12/20

Hello! Following up on this thread... has there been any change recently to show the time in the date/time columns? We are creating a deployment plan in Smartsheet and each task is using duration in minutes (or hours). But we are not able to see the true completion time, only the date. If this is not yet possible, what is the workaround?

Andrée Starå · 10/17/20

Hi@SuzanneH

Please have a look at my post below with a method I developed.

More info:

Hi all,<\/p>

I hope you're well and safe!<\/p>

I've developed a solution that lets you store the date or value.<\/strong><\/p>

You'd use the copy-row automation and a VLOOKUP or combination of INDEX\/MATCH to make it work.<\/p>

We'd trigger the copy-row to another sheet and get the created date\/other value and then use the VLOOKUP\/INDEX\/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id\/value that we can use, it will work.<\/p>

Also, this opens up more options with auto-numbering and similar.<\/p>

Depending on other workflows, you could reuse one sheet for multiple workflows.<\/p>

I hope that helps!<\/p>

Let me know if you have any questions!<\/p>

Stay safe and have a fantastic day!<\/p>

Best,<\/p>

Andrée Starå<\/p>

Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>","bodyRaw":"[{\"insert\":\"Hi all,\\n\\nI hope you're well and safe!\\n\\nI've developed a solution that lets you \"},{\"attributes\":{\"bold\":true},\"insert\":\"store the date or value.\"},{\"insert\":\"\\n\\nYou'd use the copy-row automation and a VLOOKUP or combination of INDEX\\\/MATCH to make it work.\\nWe'd trigger the copy-row to another sheet and get the created date\\\/other value and then use the VLOOKUP\\\/INDEX\\\/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id\\\/value that we can use, it will work.\\n\\nAlso, this opens up more options with auto-numbering and similar.\\nDepending on other workflows, you could reuse one sheet for multiple workflows.\\n\\nI hope that helps!\\n\\nLet me know if you have any questions!\\n\\nStay safe and have a fantastic day!\\n\\nBest,\\n\\nAndrée Starå\\n\\nWorkflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2020-05-24T11:36:34+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/68589\/lock-or-store-date-value-solution-without-using-zapier","embedType":"quote","name":"Lock or Store Date\/Value Solution without using Zapier"}"> https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

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

Nancy Heater · 11/06/20

Hi@Andrée Starå-

Checking on this thread to see if there are any updates on having date and time captured in a single cell?

We have to calculate duration of time for our reporting (example below), that I am trying to move into Smartsheet. Without this functionality, we're stuck with our current solution. Thanks!

Graham Rimell · 11/11/20

I'm encountering the same problem. No ability to cope with time. Which is pretty weird considering that the Autodate columns actually lists date and time. However if you then reference that column in another date column it strips out the time information.

Seems that people have been asking for this function for nearly 3 years and still no sign of it. It'd be nice to have an idea if it's even in the pipeline for development. It seems like a core basic function, a strange one to omit.

Amandeep Chugh · 12/10/20

That's a very important feature for us too. Manually adding time as a text is so very prone to errors!

Manzoor Mehaboob · 01/13/21

Is there any solution available now in SmartSheet?

Andrée Starå · 01/13/21

Hi@Manzoor Mehaboob

Unfortunately, it's not possible natively at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

There might be a workaround, but it depends on your specific use case.

Can you elaborate on how you'd want to use it?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

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

JeremiahHorstick · 01/14/21

Interestingly I have seen that date type columns do indeed contain date/time data however it can only be exposed via the API.

We could take the dates from a critical path with minute duration values and present it in a text column if you want.

Time Test Sheet for Demonstration:

Time Data exposed by API:

We could make the time data readable and/or put it in a format that hours/minutes/seconds can be accessed with a formula.

SJ Sellers · 04/14/21

You don't even need the API to expose it - you can expose it RIGHT in the sheet itself with

=[Due Date]@row + ""

The problem is that there is no ability to SET the TIME in either the Start Date or End Date columns. All tasks start by default at 8am unless they have a dependency on another task. If your task should actually start at noon you are out of luck.

AmyB · 09/29/21

I figured I'd chime in here and also say that I also could really use a time format column. It's keeping me from moving some processes from Excel to Smartsheets as well.

zcornute · 11/01/21

You don't even need the API to expose it - you can expose it RIGHT in the sheet itself with <\/p>

=[Due Date]@row + ""<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/L7OQIO6GCLW1\/image.png<\/a><\/p>

The problem is that there is no ability to SET the TIME in either the Start Date or End Date columns. All tasks start by default at 8am unless they have a dependency on another task. If your task should actually start at noon you are out of luck.<\/p>","bodyRaw":"[{\"insert\":\"You don't even need the API to expose it - you can expose it RIGHT in the sheet itself with \\n=[Due Date]@row + \\\"\\\"\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/L7OQIO6GCLW1\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/L7OQIO6GCLW1\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The problem is that there is no ability to SET the TIME in either the Start Date or End Date columns. All tasks start by default at 8am unless they have a dependency on another task. If your task should actually start at noon you are out of luck. \\n\\n\"}]","format":"rich","dateInserted":"2021-04-14T19:55:15+00:00","insertUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2023-08-23T20:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/287393#Comment_287393","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/287393#Comment_287393

This isn't working for me. When I apply it to a cell it just gives me the date only.

So I have a Last Updated column that is a Date type, then I created a temp column just to test this where I apply the function [Last Updated]@row + "" to a cell in temp and i just get the same value I have in Last Updated. I've tried changing the column type for temp to both Date and Text/Number

How to have a Date and Time format for Date Column Properties?

Answers

Help Article Resources

Categories