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 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.

I assumed this meant I should create a Helper column to do the logic separately in a column, but I don't see a way to evaluate against whoever the "current user" is.

I've searched thru docs and a bunch of old forum posts, but must be looking in the wrong places because I haven't found anything that offers a solution. (I'm on a Gov tenant, btw, if that matters.)

Thanks!

Jamie

Find more posts tagged with

Sheets

Filters

Smartsheet Gov

current user

Accepted answers

All comments

Ape_Man819

Think this would/should work.

Steps to Create the Filter:

Open your sheet in Smartsheet (web version).
Click on the Filter icon (funnel symbol) in the toolbar.
Click + New Filter.
Give your filter a name (e.g., “My Open Tasks”).

Add the following conditions:

Condition 1:

Column: Status
Condition: is not
Value: Complete

Condition 2:

Column: Assigned To
Condition: has any of
Value: Current User

Condition 3:

Column: Consult With
Condition: has any of
Value: Current User

Combine Conditions:

Change the logic from "All conditions must be true" to "At least one condition must be true" for the Assigned To and Consult With conditions.
So the logic should be:
- Status is not Complete AND
- (Assigned To has Current User OR Consult With has Current User)

Smartsheet doesn’t support nested logic directly in filters, but you can work around this by:

Creating a helper column (e.g., “User Involved”) with a formula like:

=IF(OR(HAS([Assigned To]@row, USER ()), HAS([Consult With]@row, USER ())), 1, 0)@row, USER

2. Then filter where:

Status is not Complete
User Involved = 1

Andrée Starå

https://community.smartsheet.com/discussion/139427/function-for-current-user-to-use-in-formula

Hi,

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Paul Newcome

@Ape_Man819 You may want to double check your sources. Some of the functionality mentioned in your post is not available within Smartsheet.

Jamie Bedford

I just submitted a Feedback Idea — feel free to upvote it if you think this would be useful functionality:

Function() or @argument for "currently logged in user" for use in Sheet formulas — Smartsheet Community

And yeah, @Ape_Man819's suggestion looks good, but seems like it might just be AI generated without having actually tested it? The suggested "USER()" function is exactly what I'm looking for, but it does not actually exist:

https://help.smartsheet.com/function/user — 404 not found

Andrée Starå

https://community.smartsheet.com/discussion/comment/484401#Comment_484401

Excellent!

Upvoted! ⬆️

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

jmyzk_cloudsmart_jp

Hi @Jamie Bedford

Great question — you're definitely not alone in wanting this kind of dynamic filtering based on the currently logged-in user. Here's a summary of what is possible today and the limitations that remain:

1. No Built-In Formula for Current User
As you've already confirmed by @Paul Newcome, there is currently no USER() function in Smartsheet formulas that evaluates to the current viewer. So while your idea makes total sense, there's no native way to check if the current user is in [Assigned To] or [Consult With] using formulas alone.

2. Filter Workaround with Helper Column
A semi-manual workaround is to create a helper checkbox column to pre-flag the rows for each user. For example:

https://app.smartsheet.com/b/publish?EQBCT=9a0cdef45cf9493585c484ba0ac33fe5 (The image shown is from Demo Cloudsmart's perspective)

Create a filter like "Not Current User"

Manually check rows for yourself in the helper column based on that filter

Then apply a second filter, "Current User", using the condition Helper is not checked to remove other rows.

(To make it easier to focus on open tasks, apply conditional formatting to automatically strike through rows where Status = Complete. This helps quickly distinguish open from completed work, even when complex filters aren’t possible.)

This works for your own view, but as you mentioned, it's not scalable — you'd need one helper column per user (e.g., Not Current User - Juni, Not Current User - Demo, etc.). Definitely not elegant for a multi-user sheet.

3. Using Reports Instead
If your goal is to have a dynamic view per user, a Report is currently the best Smartsheet-native option. Reports can filter by "Current User" in contact columns like [Assigned To] or [Consult With] and combine AND/OR logic more flexibly.

https://app.smartsheet.com/b/publish?EQBCT=46fdeb23cf7f44bd8e8c842b18fc6580

4. API Workarounds and OAuth Note
There is a Get Current User endpoint in the Smartsheet API, but it will always return your identity based on the token you're using. So if you want to dynamically retrieve someone else’s identity (i.e., whoever is viewing), you'd need to set up OAuth and let each user authenticate. This allows you to use their token to fetch their identity programmatically, but setting up OAuth is complex and outside typical sheet usage.

So yes, your conclusion is spot on:

We still need the new feature @Andrée Starå suggested.

And thank you for submitting the feedback idea! I’ve upvoted it and definitely encourage others to do the same. A built-in CURRENT_USER() formula function would open up a lot of powerful use cases.

Jamie Bedford

Thanks, @jmyzk_cloudsmart_jp!

1, 2 and 4 are kind of non-starters for me for various reasons (most of which you mentioned), but using a Report instead is the closest I've come to what I'm actually trying to do.

The main problem with the Report approach is that Reports lack the "include parent rows" functionality that Sheet Filters offer, which means that the task and subtask level rows lose context of where they belong in the overall scope.

If there's a workaround for that, then Reports could potentially be a solution… Do you have a recommendation for that? I again assume I'd need some kind of magic Helper column that I could include in the Report filters, but it feels like it'd need to be kind of recursive / self-referential or something, and that kind of formula is not my expertise…

jmyzk_cloudsmart_jp

Hi @Jamie Bedford

Using a helper column, such as Breadcrumbs, is a standard practice in this case.

=JOIN(ANCESTORS([Task Name]@row), "> ")

https://app.smartsheet.com/b/publish?EQBCT=9a0cdef45cf9493585c484ba0ac33fe5

Then, use the column in the report.

Jamie Bedford

Thank you - that's useful! It's not as visually useful or as easy to understand at a glance, though… Having the same functionality exist in Reports as exists in Sheets to "include parent rows" would be far preferable to keep the visual style consistent. I've upvoted an Idea or two that seem to have been asking for this for months/years, but I'll use this in my Report for the time being.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.