Date Formula

Options

Hi Brain Trust

I have a sheet with Parent row - with a sub Phase row and then the children - example below

I need the

Light Grey Cells to reflect the earliest date of the children underneath it

The Dark Grey Cells to reflect the earliest date of the light grey cells - there are several of these sub phases

Light Blue Cell to reflect the earliest date of all the dark grey cells(phases)


Is this do able??

Answers

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Options

    Hi @Susan van Niekerk

    For the earliest date formula with children you can use =MIN(CHILDREN()). For the latest use MAX.

    In my experience when this is needed, I try to make it so no information is manually inputted into the parent rows. That way the parent rows can be locked. Otherwise users tend to not realize there's a formula there and input values over it.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!