Report not showing data from a sheet

Artiom Solovei · 12/29/20

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?

Mike Wilday · 12/29/20

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.

Mike Wilday · 12/29/20

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.

Artiom Solovei · 12/29/20

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.

Artiom Solovei · 12/29/20

Here you can see that the smartsheet is added to report. It should show just 1 row for now. But it doesn't.

Ayelet Weiner · 12/29/20

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?

Artiom Solovei · 12/29/20

The filter is set up only by Due Date column

Mike Wilday · 12/29/20

@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.

Ayelet Weiner · 12/29/20

https://community.smartsheet.com/discussion/comment/273255#Comment_273255

In your screenshot it shows 2 filters. I'd double check that.

Also, try what @Mike Wilday suggested and let us know.

Artiom Solovei · 12/29/20

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

Mike Wilday · 12/29/20

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.

Artiom Solovei · 12/29/20

There is no cheeseburger column any more. that column was just to show you that the row is not added

Mike Wilday · 12/29/20

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.

Artiom Solovei · 12/29/20

Yep this was the problem. There was a mess in the filter. I organized it. Now it works )

Thank you very much

Mike Wilday · 12/29/20

Great! I'm glad we could help you figure it out.

Report not showing data from a sheet

Best Answer

Answers

Categories