Can i join a Max value and a Min Value of child rows?

Katie Barnett

I have a sheet with a process listed out and stages nested under the parent stage. I want to add a formul at the parent level to show the phase range. I want to write a formula that will Join(Collect) the minimum and maximum value of the child rows.

=JOIN((COLLECT(((MAX(CHILDREN()))), "-", (MIN(CHILDREN())))))

Genevieve P.

Hi @Katie Barnett

You don't actually need the COLLECT function here. You can either use JOIN, or I would simply add your two formulas together with the "-" in between like so:

=MAX(CHILDREN()) + " - " + MIN(CHILDREN())

Let me know if this is what you were looking to do!

Cheers,

Genevieve

Genevieve P.

Hi @Katie Barnett

You don't actually need the COLLECT function here. You can either use JOIN, or I would simply add your two formulas together with the "-" in between like so:

=MAX(CHILDREN()) + " - " + MIN(CHILDREN())

Let me know if this is what you were looking to do!

Cheers,

Genevieve

Katie Barnett

Thank you that worked!