Date not recognized in column
I have data coming into Smartsheet from a Microsoft Form, and I'm not sure how to get smartsheet to recognize the data as a date. I tried to create an additional Date column, and putting in a formula to copy the date from the original column (hoping that the settings of the new date column would make the data officially a date, but it just appears to be text). Tried creating reports based on the date column and it doesn't recognize the data as a date. Seems like this should be easy and I'm just missing something obvious...
Help Article Resources
Check out the Formula Handbook template!