Return Maximum value of a column, but only from Child Rows.

Options

I want a column formula that will return the maximum value of values in another number column [Inventoried Qty], but only assess the values in that column from child rows.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @RKLRpp

    With a sheet like the example above, there are a couple ways you can do it.

    First way is to point to the entire Inventory Qty column. It will evaluate all child rows even if there are multiple parent rows. Then it will give the maximum value for the column excluding parent rows so in the example above the result would be 20.

    =MAX(CHILDREN([Inventoried Qty]:[Inventoried Qty]))

    Second way to do it is to point at the parent row cell in that column for it to evaluate only that parent and no other parents' children. The result for the formula below would also be 20 because I pointed it to the children for "testing 2".

    =MAX(CHILDREN([Inventoried Qty]6))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!