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
Check out the Formula Handbook template!