Dashboard Widget Not Calculating

I am really struggling with this one! On my dashboard, I have a widget that calculates a count of my status items by color. As you see below, Blue status is tracking at 47 but my Green status shows 0.

When I click on the Green status, my report behind it shows 11 items (sample below)

When I edit the widget, and go into Data Source & Layout, the count for Green is 0.

Has anyone run into this and been able to resolve?


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Heather Doucette

    It looks like you have a Formula in a Sheet Summary section of your sheet that we'll need to fix.

    First, go to the actual source sheet. Then click on the Sheet Summary button on the right, which will open up the panel.

    Find the field that says "On Track" and click on the 0 to expose the formula behind the number. You'll want to check that it's looking at the correct column in the column reference (see here), as well as that it's searching for the correct criteria. For a green status ball, you want to search for "Green", like so:

    Let me know if you need help once you've found the formula! It would be useful to see a screen capture like the one above which shows the column as well as the open formula.