Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    Metrics not matching Dashboard

    ✭
    in Smartsheet Basics

    Hello,

    I have a metrics sheet (as seen below)

    image.png

    The numbers in the last row are averages of the numbers above them. When I go into my Dashboard and I select the above metrics sheet to use for my 'Metric Widget' the averages do not match (as seen below) in 2 columns. I have saved and refreshed several times and I've also fully exited out of both the Metrics Sheet and the Dashboard a few times but for some reason, the averages in 2 of the columns still don't match.

    image.png

    any ideas about how I may be able to fix this?

    Thank you,

    Amelia P.

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • Employee
      Answer ✓

      Hi @Amelia P.,

      Have you tried deleting and recreating the formulas that are showing the incorrect values from the dashboard? I would attempt this, then save the sheet and then open the dashboard in the same browser tab.

      If that doesn’t resolve the issue, the best next step would be to open a ticket with our Support team so they can take a look at this specific sheet and dashboard and communicate with you via private channels. If you open a ticket, please provide them with these screenshots as well as the IDs of the sheet and dashboard (open the item and click File > Properties to find the ID). 

      Thanks,

      Georgie

      Need more information? 👀 | Help and Learning Center

      こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭✭
      edited 01/28/25

      Hi @Amelia P.,

      Have you by chance made a copy of your workspace and/or files? If so, is there any chance you're pointing the Metric Widget at the incorrect copy?

      Click Reject on this comment if it is not the solution, and your question will go back into the queue for others to examine.

      · Share on FacebookShare on Twitter
    • ✭

      Hi there,

      No, there are currently no copies :/

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭

      @Amelia P.,

      Ok then, I'm stumped.

      Please "reject" all comments, and your question will return to the "Unanswered Questions" queue for review by other community members.

      All the best,
      -Ray

      · Share on FacebookShare on Twitter
    • Employee
      Answer ✓

      Hi @Amelia P.,

      Have you tried deleting and recreating the formulas that are showing the incorrect values from the dashboard? I would attempt this, then save the sheet and then open the dashboard in the same browser tab.

      If that doesn’t resolve the issue, the best next step would be to open a ticket with our Support team so they can take a look at this specific sheet and dashboard and communicate with you via private channels. If you open a ticket, please provide them with these screenshots as well as the IDs of the sheet and dashboard (open the item and click File > Properties to find the ID). 

      Thanks,

      Georgie

      Need more information? 👀 | Help and Learning Center

      こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

      · Share on FacebookShare on Twitter
    • ✭

      Sounds good, Georgie - Yes, I have tried the suggestion and now I'm waiting to see if it behaves the same way it was behaving the past couple of days but thank you for your help! I'll be sure to open that ticket if need be, thanks again!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video