Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Reports : Missing title on column in report

Hello,

I currently have a messy report with four sheets that I wanted to clean up. I noticed the information was being separated due to slight differences in the titles. So, I went through all four sheets and made sure the titles were exactly the same, then I created a NEW report.

This is from the messy report. I not sure how these sub categories were added (boss created report)

But now after I created a NEW report I don't see, Primary Column as an option in the Columns or J-1 Visitor Name

I just noticed that the first Column is labeled as Primary Column in the messy sheet and the new sheet is just Primary? I didn't title that

Also, I randomly checked the Filter Criteria in the NEW sheet and J-1 Visitor Name is there, but doesn't appear in the columns tab. There are no subcategories in the new report either.

Answers

  • Community Champion

    Hi @SDSU

    When you create a new report, the Primary column from your source is auto added and is named always as just Primary. You can double click on it and change it to any value, in this case, as J-1 Visitor Name as that is the primary column in your source sheets.

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • But why isn't J-1 Visitor Name title on my columns list in the New Sheet? It's on the old one, I just have J-1 Visitor Email. I changed the primary title to J-1 Visitor Name but I am still missing the information.

  • AHH I figured it out! In one of the 4 sheets I had hidden the primary column because it was a title duplicate. I now rename the primary and added the contents from the other duplicate and deleted that one. Now they appear in the primary column in both reports. Thank you!

Trending in Smartsheet Basics