Parent Formula to display modified child status

Cuatro ✭✭
edited 12/09/19 in Formulas and Functions

I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change.

For example:

If I change the status of "Software" to Red (R) in the child row, it should change the Parent status to Red.

The parent row captures any child row that changes from Green to Red and vice versa.

Any help would be awesome. Thank you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!