How can I change the date format in Dynamic View?
Answers
-
Hi
As far as I know, there are no settings for date format in Dynamic View. Unfortunately, there's nothing we can do about it at the moment. However, you can request an enhancement for upcoming Dynamic View releases.
Gia Thinh Technology - Smartsheet Solution Partner.
-
I just did a work around for this in Dynamic view. I have a "Created" column in the sheet that is in my workspace that is automatically filled in with the date and time when the form is submitted. Since the date and time format in Dynamic View does not look like I need it to I did this work around.
I added an "Entry Time" and "Date" Column in the sheet with my automatic date and time column named "Created" I used the formula =RIGHT(Created@row, 8) in the Entry Time Column and =LEFT(Created@row, 8) for the Date column to extract the date and time out of the Created column. Now that you have those removed you can go to dyamnic view and remove the Created column from the View Display in settings and add your Entry Time and Date columns into the View Display.
Now in your Workspace in your sheet you can hide the "Entry Time" and "Date" column so you don't have double date and time columns on your sheet.
Now you can clearly see the time and date in Dynamic View.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives