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??
Answers
-
Are you able to provide a screenshot for context?
-
@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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!