How do I make some columns on a children's row update to match the parent as parent cell changes?
Hello,
I have a spreadsheet I was given that has styles listed out as Lots which are product specific and then below are children rows that are listed out as SKUs which are product/color specific. In order to not have to alter the same information on each SKU row, how do I make the SKUs row alter it's information based on what is changed in the parent row. Example: if my parent row is marked in process - all the children rows automatically move to in process as well.
Answers
-
@Rhea You could leverage the Ancestors() function: https://help.smartsheet.com/function/ancestors
Now, you'll need to wrap the ancestors() function in a JOIN() in order to get the value to be displayed as text.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives