Put most recent date in a column header
Hello, I need a little help with this one. I have an end date column where I would like the most recent date to appear in the column header. I'm not using a Gantt chart so I'm doing this manually.
The red arrow shows where I would like the most recent date to appear.
Thank you!
Answers
-
Do you have the other rows indented underneath the top row? If so, you can use
=MAX(CHILDREN())
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks Paul.
Yes, the other rows are indented but the top row is restricted to a date format. When I place the formula in the cell and update the child rows, the column header is blank. Not sure what's going on there.
-
Are you able to provide a screenshot that includes the primary column so we can see the indentations in the sheet?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!