Find the minimum and maximum dates for child rows

This discussion was created from comments split from: Find date formula.

Answers

  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭

    Hello, I'm trying to find the minimum and maximum dates for my child records, but only the MIN function is being accepted. I'm getting an error when using the MAX function. Also, I can't add the MIN to the next Parent to find the MIN from all its children that have additional children. Is there a better option to use for Dates?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    What error are you getting?


    What do you mean you can't add it to the next parent? I have hundreds of sheets that are set up like this, so it should be working for you.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com