-
Request to Restrict Sheet View by Current User in Report
Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows relevant to them. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form. Here's the situation: I have a sheet…
-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
No Dropdown for the 'Enter Value' cell in my report filter/s listing "Current User"
I'm trying to create a report using the 'Current User' filter feature. However, when I attempt to setup the filter in the report that I just created, there's No Dropdown for the 'Enter Value' cell. I just get a text box. Also, the 'Enter Value' text box has a red outline prior to attempting to type something. Nothing…
-
Current User Dashboard Help
Hello there! I am trying to build an employee portal where one of our staff can see a dashboard that contains just their information. I have two sheets, one that tracks TO DO's and one that tracks GOALS. I would like them to see only their assigned tasks. I know there is some way to set this up so the dashboard shows only…
-
Report Not Showing the Correct Information on Dashboard
I am embedding a report onto a dashboard. The user that should have information displayed to them has permissions on the source sheet, report and dashboard. Even when I click into the report with the user's login information I can see the desired info, but when its displayed on the dashboard, it doesn't show any…
-
"Current User" Report filters applied to report widgets on Dashboards
Usually report filters carry over to reports in a widget on a dashboard. However, the Current User option in report filters does not carry over. This would be very helpful in building dashboards and reports so I only have to build and maintain 1 of each rather than build multiple of each for each manager/area I want it…
-
Sharing a Filter By Current user report without sharing the sheet
Here is what I am attempting to do. I have a sheet where people use a form to submit requests. These could come from anybody in the company (over 100,000 people) I would like to have a report, on a dashboard, where these people can come in and see the status of their request. I was hoping to create a report, filtered on…
-
Do we have a solution for the Magnifying Glass on the Dashboard
Hello, Do we have an option/solution for the a "current user" report/dashboard that will display something other than the magnify glass message below……maybe like "Great Job!!! You are current."…..or a solution that could be customized…. other than the Magnify Glass Message?
-
Current User Report - "Current User" not showing as an option in drop-down menu
Hi all. I'm creating a current user report, but "current user" is not showing as an option in the drop-down menu (see below screen shot). I built out this report previously with no issues and when I checked the filters today, the current user one wasn't working. Thanks for any insight!