Skip to content
  • Try Smartsheet

    • Add Ons and Integrations

    Add Ons and Integrations

    Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

    Malfunctioning dashboard widget based on Pivot report

    ✭✭✭✭✭
    in Add Ons and Integrations

    Hello,

    My dashboard widget is showing the grand total column even though this is not a column I have selected on the source pivot report:

    Grand total showing:

    image.png

    Grand total not an option in the "Columns Included" option:

    image.png
    image.png
    image.png

    This columns header is not selected in the report (sourced by a pivot sheet).


    Can someone help me troubleshoot? I want this dashboard widget to auto-update. I don't want to have to manually add someone every time a new individual starts working on a project

    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    Answers

    • Employee

      Hello, have you tried clicking 'Edit' under 'Data Source' and clicking and dragging across cells to select the specific data you're looking to include in the chart? I've found this helpful in the past to specifically exclude a totals column.

      Hope this helps!

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

      @SolutionSal,

      This actually does not work because I would like this visual to automatically update when new resources are added to the workspace and assigned projects. If I have to manually update the visuals each time this happens, it's not very effective.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭
      Answer ✓

      @SolutionSal I actually figured this one out!

      I went to the original report and filtered out the "Grand Total" row.

      Presto!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Posts

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

     Watch video