Of course, the information about the current user is already available in the system, after all we can access it via filter. But I miss a function that would allow identifying "Currentuser()" via formula. I'm making individual dashboards and would like to generate personalized statistics for each user, which are automatically available when they access the dashboard, but I can't find an objective way to do that.
I would also love this. I could make a personalized dashboard for projects assigned to the viewer. We can already use a report to show only the lines where the contact is equal the current user. However it would be nice to make some metrics such as: Total open cases for Current User.
It would also be nice to use it to personalize text fields, such as: ="Welcome, " + [Current User].
Definitely agree! We really need to have this so we don't need to build a dashboard for each of the execs who only want to see projects statistics where they are a sponsor!
Even having a filter that kind of juxaposes the current user filter would be handy, especially for a supervisor that wants a single report for their team which is filtered based on who's viewing it, but the supervisor would want to use the exact same report to see EVERYone's items without needing a separate duplicate report or without needing to add another column for a list of contacts that are 'super users' (or whatever you want to call them) that should be allowed to see all items in the report.
If [Current User] [is any of] [selected users]
vs
If [Contact List Field] [is any of] [selected users/current user]
I feel like the best way would be similar to @cell or @row make it @user
Honestly, I thought that it was a thing at one point. But maybe I just dreamt it?
In all for this—it offers a way to consolidate sheets.
I can't figure out a way to vote, but my vote is a YESSSSSS!
Definitely a "Yes". Creating a report and loading into the dashboard is extra work.
Is there any chance Smartsheet could comment beyond "On our radar" on this issue? I am constantly running into situations where the absence of this obviously useful function makes certain functionality not possible, so if internally you know you will not be implementing it it would be good to know.
Sorry Folks, I don't know if Smartsheet will EVER approve this but I truly home that they do. The reason being because it would cost them money. Currently, there's NO WAY to hide data from people with View only access unless you pay extra for Dynamic View or Workapps. This =Currentuser() function would make it possible to create sheets that only contain data we want the logged in user to see, eliminating the current problem.
The current Problem: Even though Reports give the illusion that "current user" filters cannot be disabled and you cannot unhide columns in "view only" reports, the truth is that you must share it's corresponding "sheet" for that report to populate data. With "view" access to a sheet you can view all the data that the report hides and even export the sheet to excel and then unhide the hidden columns.
This is a MAJOR problem because I'm certain more than 50% of typical users THINK that they are only sharing what they want the "view only" user to see what the "Current User" filter allows. But the truth is that view only user always has access to ALL information in the Report because they have 100% access to the linked sheet.
If Smartsheet wants to do the responsible thing they will implement this function mentioned by OP as it would give us the ability to work around the security breach and create dynamic sheets containing only data for a specific user, thus giving us the ability to hide data we don't want users to see.
I see it's most recent status is "On Radar" so that gives me hope, but if they put this on the backburner it's likely because they love selling their addons.