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.


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!