Join Sub-Parent with Children rows
I have a sheet that has multiple parent rows and I want to join a specific Parent Row to the children rows. When I use the formula =JOIN(ANCESTORS([High-Level Workflow Task]@row), "-") it includes all the parent rows above it like this "SM RDG LO-SCO Migration-FY2023 Budget & Scope-Gadget Group X: Thin Slice#1 @5%-Batch 1/1 (150 SCO's)" I only want the Join to show "Gadget Group X: Thin Slice#1 @5%" (and remove the Batch 1/1 if possible but that is not as important as removing the higher parents
Here is a screenshot of what it is including
Help Article Resources
Check out the Formula Handbook template!