How do you summarize symbol statuses?

Kristen Christman

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??

Paul Newcome

Are you able to provide a screenshot for context?

Kristen Christman

@Paul Newcome I ended up figuring out a solution. I added another column that identified percentages (which are numerical and allow averaging) and then used the following formula to inform the symbol column: =IF([% Complete]@row < 0.25, "Empty", IF([% Complete]@row < 0.5, "Quarter", IF([% Complete]@row < 0.75, "Half", IF([% Complete]@row < 1, "Three Quarter", "Full")))).

This allowed me to identify an average for certain cells in the % column, which transcribed to the appropriate progress status/bar symbol.