Dashboard Report view not showing correct Primary Column values

Have many reports pulling from a master sheet which are functioning correctly. But when this report is viewable on a Dashboard, the preview window is not showing the Primary Column values...?

In fact, the dashboard report preview is showing a duplicate of a different column values in place of the correct Primary Column values. (screenshots

attached)

This isnt super critical to my team functions, just irritating.

Any thoughts on why this is happening?

Answers

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭

    Your report might be referencing a different sheet than you are expecting. Hard to say exactly without seeing the architecture, but I'd recommend looking at your report builder and verifying it is built properly. Additionally, that the report you are looking at on the dashboard is indeed the same report you are thinking it is.

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

  • Hello,

    I am experiencing the same issue in which the dashboard widget of my report is renaming the primary field but it looks correct in the report. It is renaming the primary field to match the field in one of the three sheets that feed my report. Here's some screenshots below

    Report:

    Dashboard Report Widget:

    I have deleted the widget and re added it. I am sure it is the mapped to the right report as I activated the widget to take me to source when clicked. Any updates or ideas?

  • Hi @bsanson

    I haven't seen this happen before with a Report widget - please contact Smartsheet Support with a screen recording showing the source Report and the widget, along with the URLs to the source sheets/reports.

    Thank you!
    Genevieve

    Need more help? 👀 | Help and Learning Center

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