Imported Dates Incorrect Format
I am copying dates from Excel and pasting into Smartsheet and cannot get the format to recognize the date correctly. For example I have two dates, 02/17/22 and 02/11/22. When I copy them into the date column in Smartsheet they show as 2022-02-17 (correct) and 2022-11-02 (incorrect). No date formatting I have tried seems to fix this. Any ideas what I'm doing wrong?
Help Article Resources
Check out the Formula Handbook template!