Dates of Parent

Alex Klingbeil
Alex Klingbeil ✭✭✭
edited 09/13/22 in Formulas and Functions

so I am looking to make something and I cant seem to find what I need.

I would like to use

EXAMPLE

Parent Date | =last date entered below or keep blank tell all Childs are filled in

Child Date 1 | 1/1/22

Child Date 2 | 12/25/21

Child Date 3 | 11/9/21

Child Date 4 | Blank


i know =MAX(CHILDREN()) will kind of work but it wont leave it blank

Tags:

Best Answer

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Answer ✓

    Hey @Alex Klingbeil,

    One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.

    =IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")
    

Answers

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Answer ✓

    Hey @Alex Klingbeil,

    One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.

    =IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")
    

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!