Creating Pie Chart with Non-numeric values

kjthacker ✭✭
edited 12/09/19 in Formulas and Functions


I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I look at the pie chart, I might see 25 green, 13 red, and 7 yellow (representing issues that we're working on or have completed.)

Any thoughts on how to make this work?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!