Report by user: Filter empty for only one user
Hi,
I have created a report by user and it works fine for all users of my sheet with the exception of one user.
The field that I have marked in yellow below is showing empty for this one user and therefore not pulling the data for her, she only gets a blank sheet.
How can I fix this?
Thank you!
Christine
Answers
-
I'm guessing the Submitted By is a contact email field? I'd suggest having the user go to their account icon in the bottom left of any SmartSheet page. It will say Sign Out and their email address that's tied to their account. Is that email address the same as the Submitted By email address listed on your sheet for them? If not, that could be the problem. Maybe this user has signed up for SmartSheet with 2 email addresses?
-
Hi Mike, thank so much for your answer! Yes, it's a contact email field. The user is on vacation right now, as soon as she's back I'll let you know if this fixed the issue.
-
Hi @ChristineN
I hope you're well and safe!
To add to Mike's excellent advice/answer.
- Ensure that the user is shared with the underlying sheets that the Report is referencing.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée, thanks for the advice! You're right, the sheet wasn't shared with her. With both of your suggestions I'm sure it'll work!!!
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives