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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives