Remove Primary Column From Report

I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.

 

Thanks!

 

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    You should be able to hide it.

    Please see the attached link/screenshot for more information.

    https://cl.ly/062X1a2Q143g

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant @ Get Done

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Teri Bledsoe
    Teri Bledsoe ✭✭✭✭✭✭

    I am having the same issue. I tried to hide the primary column from my report, but when I linked the report onto the dashboard, the data from the primary column still appeared.  I need to not have the primary column data to show up on my report at all.  Does anyone have any ideas for this?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Teri,

    Did you get it working?

    If you hide the Primary Column on the Report that you are showing on the Dashboard, it should not show up in the Dashboard.

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hey Andrée,

    I'm having the same issue. Even when I hide the Primary Column it shows up on my Dashboard chart. I have no option to remove the primary column.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @wsnow11,

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • if the report is grouped I'm unable to remove the primary column -why?

  • @Sandra Murray I'm having the same problem. Even after rearranging the columns, adding a Group moves the Primary Column back to the beginning.

  • Same. Also resizing the primary column resizes the groups, which defeats the purpose of grouping.

  • Has there been a response to this question?

    As soon as you add grouping to a report the primary column is shown and you cant remove it. Any fix or work around for this?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @MaryJo Maddison

    There currently isn't a way to remove the Primary column when you Group a Report. Grouping automatically brings the Primary column to the left of the Report, as the first column. See the Tips and Tricks section of this article: Configure grouping to organize results in report builder