-
Sharing Report "Current User" Without Sharing Sheet
Is it possible to share a report with multiple people with ‘view’ access rights but ‘current user’ access rights without having to share the sheet? Currently, I have tried sharing with those settings several times, but the report contents are not visible to the users. When I share the relevant sheet, the report contents…
-
Current User Chart from Metric Sheet Data
I am trying to create Current User Charts for a Dashboard. I know these charts are typically made by creating a report. However, I am dealing with more data then the report will support filtering. Currently, I have 4 sheets with a total of 54K rows (total across the 4 sheets). So I thought about creating a Metric Sheet and…
-
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…
-
Seat Type and True-Up ページにアクティブユーザーが表示されない不具合について
現在、Smartsheet 管理画面の「Seat Type and True-Up」ページにおいて、アクティブユーザーが正しく表示されない不具合が発生しています。 【現象】- シートタイプレポートをダウンロードすると、対象ユーザーはリストに含まれている。- しかし、ブラウザ上の「Seat Type and True-Up」ページでは同じユーザーが表示されず、ライセンス付与や管理操作ができない。 【影響】- ライセンス管理の正確性が損なわれ、運用に支障が出ています。 【要望】- アクティブユーザーが正しく「Seat Type and True-Up」ページに反映されるよう、早急な修正をお願いします。-…
-
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…
-
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…
-
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…