How a parent row can inherit cell data in row below
Hi Community!
This seems like an easy one. I would like the parent row to inherit data from child row immediately beneath (with the exception of the Primary column data). Is there a formula or other function to inherit so that if data in first child row changes, the parent row does as well?
Thanks in advance!
Answers
-
@lisa.bolger27646 it would help to show a screen capture of your sheet to see how you set it up.
-
Hi and THANK YOU!
I included the screenshot and a little more clarity on the request.
Is there a way for the Start Date and Finish Date to automatically populate under each blue heading? We want the Start Date to be the earliest date and the Finish Date to be the latest date.
Thanks again!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 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!