Dashboard Report view not showing correct Primary Column values

Options

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 ✭✭✭✭✭✭
    Options

    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.

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

    PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

  • bsanson
    Options

    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?

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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