Change Parent row status based on status of child row

Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭
in Formulas and Functions

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.

image.png


· Share on FacebookShare on Twitter

Answers

  • Kleerfyre
    Kleerfyre Community Champion

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


    image.png


    Jonathan Sanders, CSM

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

    · Share on FacebookShare on Twitter
  • Kyle Walker
    Kyle Walker ✭✭✭✭

    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", ""))))

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!