Pie chart not showing actually percent complete

AGK ✭✭
edited 09/09/22 in Formulas and Functions

@Paul Newcome Hi Paul - I found your solution for displaying appropriate percentage for pie charts in Dashboard. You had suggested entering a "helper column" =1 - [Percent Complete]@row.

Your recommendation worked for one of my pies....but not for the others.....I am only referencing the two percentages so I am confused why it would show 100 percent complete when in fact it is 0?! Any suggestions on this one?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!