Options
Sgiovinazzo ✭
08/15/18 edited 12/09/19 in Smartsheet Basics
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!
Tags:
- Sheets
- Education
- Printing
- Reports
- Solution Center
- Community Platform
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
09/21/22 Answer ✓
Options
Hi @markh10
I hope you're well and safe!
When you're starting with a sheet or similar, it's the leftmost column most of the time, but you can move it/hide it, but you can't delete the Primary Column.
You can delete the contents and replace them with other content as needed.
More info.
https://help.smartsheet.com/articles/504645-primary-column
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
Answers
Andrée Starå ✭✭✭✭✭✭
08/15/18
Options
Hi,
You should be able to hide it.
Please see the attached link/screenshot for more information.
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
Teri Bledsoe ✭✭
12/10/18
Options
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?
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
12/30/18
Options
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
wsnow11 ✭✭
01/17/20
Options
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.
1 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
01/20/20
Options
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,andree@getdone.se)
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
if the report is grouped I'm unable to remove the primary column -why?
2 · Share on FacebookShare on Twitter
Steve Holt ✭✭
02/04/21
Options
@Sandra Murray I'm having the same problem. Even after rearranging the columns, adding a Group moves the Primary Column back to the beginning.
1 · Share on FacebookShare on Twitter
Rocci Doria ✭
05/26/21
Options
Same. Also resizing the primary column resizes the groups, which defeats the purpose of grouping.
0 · Share on FacebookShare on Twitter
MaryJo Maddison ✭✭
04/22/22
Options
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?
1 · Share on FacebookShare on Twitter
Genevieve P. Employee Admin
04/25/22
Options
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
1 · Share on FacebookShare on Twitter
markh10 ✭✭
09/20/22
Options
Primary Column is suppose to be the Left most column but I moved another column to the left most side but it did not change the Primary Column.
What gives?
Ideally I want to delete the contents of the Primary Column or replace it with other contents.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
09/21/22 Answer ✓
Options
Hi @markh10
I hope you're well and safe!
When you're starting with a sheet or similar, it's the leftmost column most of the time, but you can move it/hide it, but you can't delete the Primary Column.
You can delete the contents and replace them with other content as needed.
More info.
https://help.smartsheet.com/articles/504645-primary-column
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
markh10 ✭✭
09/21/22
Options
@Andrée Starå
Thank you. I found another posting where I needed to copy the Primary column then as you suggested, copy another column's contents and paste it onto where the Primary is. Plus I can then rename the Primary column.
Thank you for your response.
1 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
09/21/22
Options
@markh10
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
Angela Setiadi ✭✭
09/05/23
Options
In order to add a chart to my dashboard, I need to delete the primary column, but doing so would result in an error. I just want to display a pie chart of domestic and international travel, but I can't since the primary keeps displaying the names of the travelers.Can the primary be made removable so that we can genuinely create a dashboard with just the components we require?
0 · Share on FacebookShare on Twitter
«12»
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.2K Get Help
- 86 Global Discussions
- 90 Industry Talk
- 398 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 42 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 250 Events
- 13 Webinars
- 7.3K Forum Archives
Watch video