Date and time cell becomes Date only cell on import

Christopher Mcintyre

Christopher Mcintyre ✭✭

05/01/20 in Smartsheet Basics

A cell like

will become the format

05/04/20 05/08/20

How do I get it to upload without changing the format?

0 ·

Answers

Paul Newcome Community Champion

05/01/20

It would need to be formatted as text.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter
Rich Stowell ✭✭✭✭✭

06/15/20

Need to be able to have a time included

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…
Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…

Help shape the future of Smartsheet.
Share your ideas and feature requests.