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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!