Is there a formula for my parent row to always pull data from the most recent child row?
I have a parent row that I am using the generate a summary of the most recent child row. My team will need to enter rows and in the children section to add their updates and I want to parent row to automatically capture the most recent notes of the child row. Is there a formula to do this?
Best Answer
-
Try this:
=INDEX(CHILDREN(), COUNT(CHILDREN()))
Answers
-
Try this:
=INDEX(CHILDREN(), COUNT(CHILDREN()))
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!