My primary column is not appearing as an option to show on report as a column?

Amna Ahmed

Project is my primary column yet when i create a report it is not even an option to pull

Mark Cronk

Hi @Amna Ahmed ,

Is [Project No] your primary column? Primaries appear on all reports. If you don't want them to be visible you can hide them.

Help?

Mark

Andrée Starå

Hi @Amna Ahmed

To add to Mark's excellent advice/answer.

You can also change the name of the Primary column in the report. Sometimes you might collect data from multiple types of sheets and want to change it to something else.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Amna Ahmed

Project is my primary column in the sheet but it doesnt appear in that report i created to even choose it

Kathryn Wells

@Amna Ahmed I'm having the same trouble with some existing reports. The primary column no longer populates in the report and I can't see it in the list of column options to disable and reenable it. Is there a glitch?

Lise Maria Svanholm

I also have this same problem. Primary column not being able to be picked in a report. Is there some way to fix this?

Summer

Looks like Smartsheet has an issue.

For me, I renamed my Primary Column on all my sheets to match one another. The reports I pull now have a "Primary Column" and "Newly Named" column and they are both primary and both have the same name but for whatever reason the report lists them as two different columns, with two different names.

Kristin C

Primary Column doesn't appear as an option because it is automatically added to the report when created and can't be removed. Is there a hidden column somewhere in your report?