Creating an 'overflow' semicircle donut chart

Kelly.T ✭✭✭
edited 08/25/23 in Formulas and Functions

I'm trying to create a semicircle donut chart in the dashboard to show how much the team overspent towards a budget.

For example, the budget is $100 per month but the team spent $150. Is there a way of creating an 'overflow' semicircle donut chart that shows the extra? Instead of showing a full semicircle donut chart for those more than 100%.

Attached is a sample for reference.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The general idea is that we are using a full circle. Since your base amount is half of that circle, the other half will add up to the same amount. This means overage plus white. Since we know that the base amount is (for example) 100, we know that overage plus white must equal 100, so you would do 100 minus overage to get the white.

    Note: You will also need to use metrics widgets to display each of the percentages.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!