Report by user: Filter empty for only one user

ChristineN

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

Mike TV

@ChristineN

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?

ChristineN

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.

Andrée Starå

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!

ChristineN

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!!!

Andrée Starå

@ChristineN

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!