Pie chart not showing actually percent complete

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


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!