Having overall sheet health based off of parent and child row?

Hi - I know this has been asked and answered similarly, but I am struggling with actually implementing the formulas.

I have created a simple sheet that I would like to have a visual R/Y/G/Gr marker at the top of the sheet that is a roll up of the all of the parent rows below. I am basing the formula structure off of this community response: https://community.smartsheet.com/discussion/70069/how-can-i-get-parent-row-roll-up-of-child-tasks-health-status.

End result would ideally be that I could have several sheets that are using the same template. From there, the visual health status could be displayed onto a dashboard. Is this even possible? And if so, is it possible to have it be averages as opposed to overall ">1,"Red""? Could it be based off the four main rows average?

Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=248c7046c2f9480eb93c35eaf5a1f994



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!