Percentage Dashboard

Lara Lehnerz

Hello,

I am looking to create a percentage widget in a dashboard. For example, I have 176 total items 5 of those items passed, 3 failed and the rest not started. How can I accomplish getting the percentages?

Thanks in advance!
Lara

Ty Werven

You could use a metric sheet maybe. if you just put into 3 individual cells: =5/176, =3/176, =the rest/176 it will give you a number and then you can convert those into the percentage with the "Percentage Format" button.

If you are looking to automate it I would have some sort of formula that uses =COUNT formula that returns those numbers automatically and then use it in the metric sheet that is pulling numbers from whatever sheet you have the passed/not started/ failed items.

You can then make the Dashboard and just select the cells using a widget option.