Display all column values on a Dashboard

Options

I would like to display all the values from a column on a Dashboard. I have worked out that I need to create a Sheet Summary based on that required column, but not sure what to do from there. I have attached an example of the column I want to display. Any help would be appreciated.

Column.png

Best Answer

  • Naeem Ejaz
    Naeem Ejaz ✭✭✭✭✭✭
    Answer ✓
    1. Create a Report:
      • Go to Browse > Create > Report.
      • Use a Row Report.
      • Set the source sheet to the one with your desired column.
      • Under Columns to Display, include only the column you want to show.
      • Use filters if needed (e.g., exclude blanks or duplicates).
    2. Save the Report.
    3. Add to Dashboard:
      • Open your Dashboard.
      • Add a Report Widget.
      • Select the report you just made.
      • Resize/format as needed.

    Best method for listing multiple values directly from a column.

    PMO & Smartsheet Consultant

    naeemejaz@hotmail.com

    00923455332351

Answers

  • Naeem Ejaz
    Naeem Ejaz ✭✭✭✭✭✭
    Answer ✓
    1. Create a Report:
      • Go to Browse > Create > Report.
      • Use a Row Report.
      • Set the source sheet to the one with your desired column.
      • Under Columns to Display, include only the column you want to show.
      • Use filters if needed (e.g., exclude blanks or duplicates).
    2. Save the Report.
    3. Add to Dashboard:
      • Open your Dashboard.
      • Add a Report Widget.
      • Select the report you just made.
      • Resize/format as needed.

    Best method for listing multiple values directly from a column.

    PMO & Smartsheet Consultant

    naeemejaz@hotmail.com

    00923455332351

  • Chard
    Chard ✭✭

    Hi Naeem,

    Thanks for this, worked perfectly! 😀