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.
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.
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
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.
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
What I intended to do is super simple: bring two sheets into one Row Report and do a simple pie chart on the status field. -> Source Data: two sample sheets A&B have exactly same fields. and the status is a dropdown list with single value -> The roll up row report, only picked the status field from the two source sheets.…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.