how to compare one parent child value with another parent child value?

first parent child has startdate and end date and second parent child has startdate and enddate, how can i compare both dates are greaterthan or equal or inbetween

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    My suggestion would be a helper column with the following in the child rows:

    =PARENT(Infos@row)


    Now that we have the material also listed on the child rows, you can use this to flag the rows at the top...

    =IF(COUNTIFS([Helper Column]:[Helper Column], @cell = Infos@row, Startdate:Startdate, @cell <= Enddate@row, Enddate:Enddate, @cell >= Startdate@row) = 0, "Green", "Red")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!