Column data not appearing in report

kfkfkfkf_343 · 04/14/22

hi! i'm running a report without a filter to show the "themes" and "due dates" and a few other columns. the theme data is not appearing in the theme column for two of the sheets in my report. can you help please?

below you can see all 3 sheets are included:

below you can see the "theme" column is included:

below you can see the "cisl" sheet in fact has data in the theme column:

and so does the "intl" sheet:

i read another thread asking a similar question and it turned out the filter was what was causing the problem. i removed all filters to test to see if this fixed it.

the only thing i can think of is that the sheets all have forms linked to them and i have used a label on the form. ?? any ideas? TIA

kfkfkfkf_343 · 04/19/22

Thanks for your suggestion, Jeff. I figured it out. In the two sheets where the data was not appearing, the "Theme" column type was different (dropdown single select) from the column type (text) of the sheet where it was appearing. I guess it's safe to say then column types must be the same across sheets for reporting to work. Weird. You'd think it'd be as simple as grabbing whatever data appears in the cell.

Thank you again and hopefully someone else will benefit from this.

Jeff Reisman · 04/15/22

@kfkfkfkf_343 Chag Sameach!

That's a strange one. Have you tried creating a new report with just the CISL or just the INTL sheet? If so, does the Theme data show up there?

(The field label on a form is merely cosmetic, it does not change the column name in the sheet, so you can rule that out.)

kfkfkfkf_343 · 04/19/22

Thanks for your suggestion, Jeff. I figured it out. In the two sheets where the data was not appearing, the "Theme" column type was different (dropdown single select) from the column type (text) of the sheet where it was appearing. I guess it's safe to say then column types must be the same across sheets for reporting to work. Weird. You'd think it'd be as simple as grabbing whatever data appears in the cell.

Thank you again and hopefully someone else will benefit from this.

Jeff Reisman · 04/19/22

https://community.smartsheet.com/discussion/comment/326629#Comment_326629

Glad you figured it out! Thanks for sharing your resolution here for others to find. You can mark your own answer as Accepted!

kfkfkfkf_343 · 04/19/22

Done.

Column data not appearing in report

Best Answer

Answers

Categories