Pie Chart graph is not updating

tim_sims23
tim_sims23 ✭✭✭
edited 04/04/25 in Formulas and Functions

Hello all,

I am working on a project where I am tracking the number of users that have been updated to Windows 11. I've created a pie chart on a dashboard to reflect that data. I am trying to reflect the total number of users that need to be addressed and the total percentage of users that have been completed. Although I can see my percentage increase when the sheet is updated, the graph itself is not moving. Ive attached some images and my formulas. Maybe there is something that I am doing wrong. I am using summary fields for my calculations and connecting those fields with the pie chart. I hope someone can point me in the right direction.

Thank You in advance.

The formulas for each summary field are as follows. There are emjois in the formulas because this data is feeding into ss as data shuttle from a shared excel file.

Upgrade Status
=COUNT([Upgrade Status]:[Upgrade Status])

Completed
=COUNTIF([Upgrade Status]:[Upgrade Status], "✅ Completed")

Not Scheduled
=COUNTIF([Upgrade Status]:[Upgrade Status], "📅 Not Scheduled") + COUNTIF([Upgrade Status]:[Upgrade Status], "📅 Scheduled")

% Complete
=Completed# / [Upgrade Status]#

pie chart.png data.png

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!