converting to a column formula

I am attempting to =IFERROR(SMALL([Lowest Quote]6:[Lowest Quote]9, 1), "") into a column formula I am unsure of the changes needed to make it work. I want to have the lowest quote in the children tasks to populate on the parent task bar.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @Stevie

    Is this the type of thing you want to display?

    Parent Rows collapsed:

    image.png

    Parent Rows expanded:

    image.png

    Those can't be column formulas because then the value needing to be entered into the Children rows couldn't be entered. They'd just be blank cells like this and not editable:

    image.png

    You can however enter this into each parent row's Lowest Quote cell:

    =IFERROR(SMALL(CHILDREN([Lowest Quote]@row), 1), "")

    Or you can make a column formula in a different column that is only used for the parent row's calculation formula. Like this:

    image.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!