Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Problem with "Current User" Report Data
I use a shared report for my team that populates based on "Current User." This report works fine for everyone except one person, to which it will not populate their data.
Most of my sheets have a column called "Reporting Flags" to which i apply a verbal descriptor to pull certain rows into my report. So my report criteria is as follows:
-All sheets/workspaces included
-user is Current User
-Reporting Flags does not contain "NoResource"
The user that has problems with the report also is working in sheets where "Reporting Flags" column does not exist - could this be the reason this report fails for them? As soon as i remove the reporting flags rule, the report works fine... which leads me to believe this column is somehow breaking the report when it is absent from a sheet. Not only that, it prevents data in sheets that do have this column from showing up in the report as well.
Thoughts? Thanks community
Comments
-
Brent,
If the user is not shared to sheets with the "Reporting Flags Columns" or does not use those types of columns they will not meet the report criteria you have set up of
-Reporting Flags does not contain "NoResource"
Therefore, no rows will show up
You could create a report specifically for this user, as it seems they need different criteria.
Ben
-
The user is shared to both the "Reporting Flag" column sheets, as well as some without this column. My question is, why does the report populate no data at all, even though they have rows in sheets where this column DOES exist?
It seems like as soon as there is at least one sheet where this column is missing, the report stops returning any data at all.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives