Add Dates into Summary Rollup Values as Text
Hi! I have a sheet with a bunch of summary data at the top (which will be used in reports and Control Center). Two of the summary fields I want to capture are project Start Date and project End Date which are based on the start and end dates from the plan. However, my summary fields are text fields instead of date fields so I can't just say =Start17 (column is Start and row is 17).
After reading a bunch of posts, it looks like I can do =Start17 + "" to essentially add something to the end of the date. That's work except that my dates now appear as 03/08/24 8:00 AM.
I don't want the time portion. Is there a way to pull the date into a text field and have it display as only the date (no time)?
Best Answers
-
Try using the DATEONLY() function. Would look like:
=DATEONLY(Start17) + ""
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Answers
-
Try using the DATEONLY() function. Would look like:
=DATEONLY(Start17) + ""
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!