Current User Filter showing blank report

I am trying to use the current user filter for a report I setup. The filter is based on the Project Manager Contact List Column and the report should show records when the Project Manager column is = Current User. It works for me but no one else. The people have editor rights to the underlying sheet and to the report itself.

The filter is Project Manager --- Has any of --- 1 value selected (Current User).

I've also confirmed the users are logged into smartsheet with their correct email/user name.

Any thoughts?

Find more posts tagged with

Reports

Accepted answers

All comments

Andrée Starå

Hi @Richard Kendall

Strange!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrea Zenner

@Richard Kendall Did you get an answer to this? Our current user filtered reports just stopped working last week. They were working fine, then stopped. I have a ticket in with SS but have not heard back yet.

Like you our users are shared to the sheet but their current user filtered report shows blank. The weird thing is they WERE working then just all went blank last week.

Thanks!

Andrea

Katie Wolf

We have had the same thing happen. We submitted a support case, but we found a temporary fix if you change the column type from Contact List to Text/Number and back to Contact List. I will update when I hear from support?

Nasir@EBC

Hi all

I am facing the same issue now!

But there seems to be no solution to this problem.

When I see my own report then it shows the correct data for the current user; but surprisingly when when someone else opens that report, it shows BLANK!

Any help please?

Thanks

Genevieve P.

Hi @Nasir@EBC

Are the users opening the Report shared to the underlying sheet? (See: Share or Publish Your Report)

P Lehan

Has this issue been resolved? I am having the same issue where the "Current User" option is not working on my report/dashboard.

Stephen_at_ODOC

Two years later. I'm having the same problem as in this thread. On the dashboard, a report filtered to "current user" will show up blank for all of my users. The report is set to filter "Created by" by "current user". The users created their own entries and their emails appear in the "Created by" column. For myself, it filters the report appropriately and shows only me. For other users, the report (and the report widget in the dashboard) show blank.

Genevieve P.

@Stephen_at_ODOC

Can you check your Widget settings? You'll want to ensure that under Viewer Mode the perspective is set to Their Own Perspective. Here's more information: https://help.smartsheet.com/articles/2480331-control-what-people-see-report-chart-widget

Cheers,
Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.