Add Dates into Summary Rollup Values as Text

axwestlake ✭✭
edited 03/08/24 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!