Column data not appearing in report
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
Best Answer
-
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.
Answers
-
@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.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
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.
-
Glad you figured it out! Thanks for sharing your resolution here for others to find. You can mark your own answer as Accepted!
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Done.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives