-
Current user metric widget
I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them. I have a sheet summary formula that counts the total visits and…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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!
-
Custom View for Calendar App
Is there a way to have custom views based on a group or individual identified in a column similar to the 'Current User' filter for reports?
-
Sheet Summary Report - Want to Use "Current User" Functionality
Hello, I created a Sheet Summary Report, and have found that the "Current User" functionality is not shown for selecting? Am I missing something in order to be able to do this? Or should I submit an enhancement request for this functionality? If it's not current functionality, is there reasoning behind why a Row Report…
-
Displaying who the current user is on a dashboard.
I have some dashboards set up sharing reports set up for current user. I'd like to include a who the current user is at the top of the dashboard. Thinking there is a way to use a metric sheet.... Would appreciate any thoughts on how to do this. Thanks, Sara
-
Dynamic View Current User
Dynamic View sharing is set to our domain. Users will have email address in our domain. Users will NOT have Smartsheet account. Is a Smartsheet account required for "Current User" View to work? Will it capture the Current User's email in created/modified by? We have >100 people that do not require Smartsheet for their…
-
Current User
I'm having trouble with "current user" in reports, dashboards, dynamics views and work apps. Is there a single resource, video or help guide on everything current user? Thanks, Sara
-
Can you create update requests with Current User filter capability?
Good morning. We are trying to send a workflow update request to an employee that will then update a tracking sheet — however, we do not want to share the sheet with the recipient, nor do we want the recipient to be able to select the Go To Sheet link at the bottom of the update form (which I understand cannot be removed).…
-
anyway to create formula for matching current user to cell contact list value
I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows. But even this fails since in the "standard" contact list dropdown my name…
-
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…