How do you summarize symbol statuses?

I have my team provide project status updates on their goals via a "Request an Update" automation; we use the bar symbol (empty, 1/4, half, 3/4, full). Upon an update being made, it will change the status accordingly in the respective row. I have objectives that the goals ladder up to, and I'm trying to figure out a way to summarize the goal statuses within the one objective status cell and just can't figure out the right formula. I keep getting a #CIRCULARREFERENCE error or another error. Can anyone help??


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!