Why is the Created Date column in Dynamic View so funky?

amy_ilearning

Hi, I have a source sheet set up with form submissions. One of the columns is a Created Date. In the source sheet, the column is formatted how I want it displayed - e.g. 04/01/2024 8:47 PM. But when I set up a Dynamic View pulling from that source sheet, that column looks weird.

I've made such it's formatted how I want it in the source sheet, and the Dynamic View doesn't give me the option to format it in that view. How can I get the Dynamic View to show exactly what's on the source sheet?

Genevieve P.

Hi @amy_ilearning

Dynamic View is only able to display System Column is UTC date/time format. Here's more information (Dynamic View uses the Smartsheet API): https://help.smartsheet.com/articles/2482412-how-smartsheet-handles-time-zones#toc-time-zones-and-system-columns

What I would suggest doing is use a helper column in your source sheet (that you can hide in the sheet) to surface in Dynamic View. This can simply be a reference to that Created date column + "" to turn it into Text in a Text Number column:

=Created@row + ""

Cheers,
Genevieve