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.
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.