Convert Tex to date with Data uploader

Matt@spec ✭✭
edited 12/09/19 in Formulas and Functions

Good Afternoon,

We are currently using Data Uploader to automatically move date into Smartsheet. In a few of our sheets the Date is the only unique identifier. However, I have found that using a date column to import does not work as it doubles the entries. If I upload the dates as plain text I have no issues. I have converted a many texts into dates in my time but this one seems to be alluding me. The current date comes into smart sheet as follows: 02/01/19. I am able to get it to read as a date but it will not filter nor report properly as a date. Does someone have a formula that may work to convert this to an actual date?


Thanks in Advance!!



  • Anthony M.
    Anthony M. Employee Admin

    Hi Matt,

    Thank you for reaching out! We would love to look into this deeper with you. Would you be able to submit a ticket with our Support team for continued troubleshooting on this?

    Please use the following form to submit a ticket.

    Thank you for your time, Matt. We look forward to working with you!

    Kind Regards,


    Smartsheet Support

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!