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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!