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 columns.
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 on this Sheet that shows "Open" (i.e., not Complete) Status rows where the Current User is in either
the Assigned To or
Consult With columns.
I can't figure out how to do this with the built-in Filter functionality because it cannot do complex AND/OR logic — it's either all
conditions match or any
conditions match, but not a combo. Filters also cannot do the "inverse" resultset like Reports can, so I don't think I can do an anti-filter for this Sheet filter.
Having an "@user" argument, similar to the existing @row and @cell arguments, would enable this kind of functionality.
I assume this functionality should be possible since Filters can already filter by "current user", which seems to be evaluated when the Sheet loads. The @user formula argument should be able to be evaluated at the same time.
I suppose there could be an issue with Automations/Workflows that would rely on columns that include this argument, since there would not be a logged in user (other than the System / Automation user, I suppose). Perhaps safeguards could be put in place to avoid issues like this, such as a Catch condition that could return some controlled error… but also perhaps this would just always evaluate as FALSE or N/A regardless?
I asked about this in the following Community post, but there have not been any valid solutions offered yet:
Function for "current user" to use in formula? — Smartsheet Community