Is there a way to strip the date portion off a system generated 'create date' field?
I have a column on the Smartsheet for 'Created Date' which is auto-populated when the row is created. I would like to gather just the fate portion of the date/time generated to display in a 2nd column. The point is to be able to search the 2nd column and group by date.
The system created date column is called "Created"
The syntax I am trying in the 2nd column is: =DATEONLY([Created]@row) to gather the date from the created column on the same row.
This produces #INVALID COLUMN VALUE
I have tried to replace the "@row" portion with the row number and get the same message.
Am I using the correct syntax?
Answers
-
No need for a formula. Just create another date column and set it equal to the created column. Note that the created date column is saved as server time but displayed as local time. Therefore, the date you see in the second column may be off by a day because of your time zone vs server time which is in UTC . See this video explaining how you can adjust for that if needed. Also, are you not able to search and group by date using the created column? I thought you could.... but I haven't tried that in a while :) . I do a lot of what is explained in the video below because of my timezone being a bit different than UTC so my formulas evaluate the created date column as the wrong day (for my timezone).
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!