Change Parent row status based on status of child row

Options

Hi Team,

Is it possible to that the Parent Status can default or change to Delayed only when any 1 of the Child Task row has Delayed status. Is that feasible through Automation WD or formuale.


Answers

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Options

    Yes, its totally possible with a formula. Screenshot is from the Formula Handbook Template. I totally recommend getting a copy of this.



    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

  • Kyle Walker
    Kyle Walker ✭✭✭✭
    Options

    The following should work


    =IF(CONTAINS("Delayed", CHILDREN()), "Delayed", IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(CONTAINS("Not Started", CHILDREN()), "In Progress", IF(CONTAINS("Complete", CHILDREN()), "Complete", ""))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!