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

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())))))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!