Why is the Created Date column in Dynamic View so funky?
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?
Answers
-
Dynamic View is only able to display System Column is UTC date/time format. Here's more information (Dynamic View uses the Smartsheet API):
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,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives