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

Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!