The filter is set up only by Due Date column
Report not showing data from a sheet
I created a new smartsheet with data.
Then I have added this smartsheet to an existing report
In the report i can choose columns from my new smartsheet but they are all blank.
Please advise?
Tags:
Best Answer
-
Gotcha, check those requirements in the filter and make sure that row from the other sheet matches both requirements. I have a strong feeling that it doesn't.
Answers
-
Do all of your other sheets contain the column cheeseburger with some kind of data? Look in your report for the specific sheet you are referencing in your first screenshot.
-
No other sheets doesn't have column cheeseburger. Cheeseburger column was selected because that row must be on the report.
the row is not populating on report. All other columns are the same as on other smartsheets. Specifically this new tutelashare smartsheet is not showing.
My report must show all the items from all smarthseets with next 90 day due date.
-
Here you can see that the smartsheet is added to report. It should show just 1 row for now. But it doesn't.
-
What are you filtering the report by?
On your report under the Status column, I noticed that their is a slight difference in wording for rows that are due within the next 90 days.
Could it be how you worded the Status on the new sheet?
-
The filter is set up only by Due Date column
-
@Ayelet Weiner I am seeing the same thing. There are several different status for 90 days.
Due within 90 days
Due next 90 days.
And the new sheet has the row with this language: Due in next 90 days.
Try changing the status wording on the row with cheeseburger in the original sheet to Due next 90 days and see if it appears.
-
In your screenshot it shows 2 filters. I'd double check that.
Also, try what @Mike Wilday suggested and let us know.
-
I changed the status spelling in all Smartsheet's. Still not showing.
It even does not pop up under Sheet Name column even if it is a major column tied to the name's of the smartsheet's
-
It has to be an issue with the filter. Check both requirements of the filter and make sure your row in the cheeseburger sheet meets both of those requirements.
-
There is no cheeseburger column any more. that column was just to show you that the row is not added
-
Gotcha, check those requirements in the filter and make sure that row from the other sheet matches both requirements. I have a strong feeling that it doesn't.
-
Yep this was the problem. There was a mess in the filter. I organized it. Now it works )
Thank you very much
-
Great! I'm glad we could help you figure it out.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
