Converting Year, Month, Day helper columns into a "Date formatted" Date value
Hi all - I am getting really confused by how SmartSheet handles dates.
I have an excel sheet I am importing that loads the date value as a text/number column type - [Imported Date]
I then want to convert this into a Helper column, that displays a date value, formatted as a date - [Helper Date]
I created formulas to split out [YEAR], [MONTH], [DATE] from the text date, but am now having trouble with the formula that would combine all these into one that can be placed in my [Helper Date].
Any help on this would be appreciated, thanks!
Help Article Resources
Check out the Formula Handbook template!