Pie Chart graph is not updating

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]#
Answers
-
@tim_sims23 just a heads up, dashboard status is currently experincing issues,
https://status.smartsheet.com/
Could just be a temp thingPrincipal Consultant | System Integrations
Prime Consulting Group
Email: info@primeconsulting.com
Follow us on LinkedIn!
Help Article Resources
Categories
Check out the Formula Handbook template!