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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!