Dynamic View Display Formats
I am using the Modified column to capture the date/time a row was last updated. In the sheet it displays in an easily understandable format, 05/23/21 3:24 PM. That format remains consistent in the report based on the sheet as well. My Dynamic View uses the report as its source yet the time displays in a system format which has cause some users to comment and suggest a simpler format. I've tried the Show/Hide formatting button but it has no impact on this field. Am I missing something?
Also, is there a way to define a column width and pin it? It seems to default to a set width per column every time I open a new browser window. Thanks in advance for any help or suggestions.
Best Answer
-
I developed my own workaround for this problem using a formula. Since I have another sheet where all my users are listed, I was able to combine the Modified and Modified system columns to display in a single column.
Here's the formula:
=IFERROR(INDEX({5-6 S2-CORE - Employees in SCR Preferred Name}, MATCH([Modified By]@row, {5-6 S2-CORE - Employees in SCR Email Import}, 0)), [Modified By]@row) + " on " + DATEONLY(Modified@row) + " at " + MID(Modified@row, FIND(" ", Modified@row) + 1, FIND(":", Modified@row) - 1)
Answers
-
I developed my own workaround for this problem using a formula. Since I have another sheet where all my users are listed, I was able to combine the Modified and Modified system columns to display in a single column.
Here's the formula:
=IFERROR(INDEX({5-6 S2-CORE - Employees in SCR Preferred Name}, MATCH([Modified By]@row, {5-6 S2-CORE - Employees in SCR Email Import}, 0)), [Modified By]@row) + " on " + DATEONLY(Modified@row) + " at " + MID(Modified@row, FIND(" ", Modified@row) + 1, FIND(":", Modified@row) - 1)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives