Put most recent date in a column header
Xavier Gomez
✭✭
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())
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!