format a cell to be date and time format?

Maria Dumitrica

Hi

 

I was wondering if there was / is a way to format a cell to be date and time format? We enter in when we contact a customer for the 1st time and have to track the date and time. It would be nice to do so with one cell where we click the cell and a time stamp of now (but editable) is available.

 

Is this a current feature or something possible to make?

 

Thanks

Andrée Starå

Hi Maria,

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

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use multiple columns, one for date and one for time.

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 by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Zevy Lamm

Thank you, Andrée!

If I do use multiple columns, one for date and one for time, is there a way to set a reminder let's say 24 hours after the time indicated across all columns? So for instance, I have row #1 entered as June 10, 10:00am and row #2 entered as June 20, 11:00am. Can I set a a 24 reminder so that row #1 will remind me at June 11, 10:00am, and row #2 will remind me on June 21, 11:00am?

Zevy Lamm

Or is there perhaps an integration software that I can use?

Andrée Starå

@Zevy L

Happy to help!

Yes, I think we can make it work, either with an extensive automation workflow, helper columns, or a 3rd party service.

What do you think? Which method would you prefer?

Jessika Paredes

https://community.smartsheet.com/discussion/comment/252646#Comment_252646

that feature was asked since 2016, and after 4 years nothing yet...

wow..

Andrée Starå

Hi @Jessika Paredes

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

More info: 

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 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 by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!