automatically apply =Min/Max of descendants formula to parent rows based on hierarchy number?

is there a way to make those 4 date columns automatically apply the min/max formula once hierarchy is changed to 2? converting to a column formula does not let me edit the white/blank hierarchy date columns. and i tried doing an automation workflow to change a cell value, and the date columns are not options (they are NOT restricted to dates only).

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 02/04/25

    This would require automation, and automation does not allow inserting formulas. Instead it enters the formula as straight text.

    Can't use a column formula because it would apply to all rows.

    It would make for a good Product Idea submission if you can't find one already submitted that you can upvote.

    Let me know if you enter or find one (share link), and I'd be happy to upvote it. I have needed this same functionality, and have searched far and wide to no avail.

    All the best,
    -Ray

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    Oh, and you can alternately use the following:

    =MAX(CHILDREN())

    =MIN(CHILDREN())

    Will yield same results as using descendants.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!