I have created a dynamic view which references the system column MODIFIED. Unfortunately, the optics of that column are not optimal. See screenshot. Any suggestions how to get this to appear merely as a standard DATE value?
Create another column.
What you need to know about using Created and Modified dates:
These dates are displayed in local time, but behind the scenes, they are stored in UTC Time. While the displayed date will be correct, if used in a formula, the formula calculates and displays based on UTC (so in Pacific time, at 4 PM every day, the dates change to tomorrow's date). This is why I don't use the Dateonly() function that pulls the date from these columns - I use the formula above to make sure I get the correct date.
(It gets even more complex in that the DATE() function has a Y2K bug - if you only feed it a 2 character year, which is all you have in the Created and Modified columns, it defaults to 1900, so you have to hard-code the century. Technically, if this formula is still around on 12/31/2099, you'll have a Y2.1K type problem.....)
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Can Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.