JOIN function for child row
I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as their ancestorial row.
This is what I have so far for the parent and child row formulas (currently seperate)
I have also attached a screenshot, The first three columns for children rows will be blank due to the parent row being pulled in from another sheet.
Any help would be appreciated, thanks!