Using "Current User" as a filter in reports

deb_63_hydracor

deb_63_hydracor ✭✭✭✭✭✭

09/29/22 in Formulas and Functions

Can you use "Current User" as a filter if the "Assigned To" field has more than one person assigned?

Screen Shot 2022-09-29 at 4.24.34 PM.png

Thanks!

Tags:

Reports

0 ·

Best Answer

A Rose ✭✭✭✭✭

09/29/22 Answer ✓

Yes, that works,

0 · Share on Facebook Share on Twitter

Answers

A Rose ✭✭✭✭✭

09/29/22 Answer ✓

Yes, that works,

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Automatically Create Status based on completed check column and finish date
I want to have a formula in my status column that makes the status "overdue" if completed column is not checked and finish date is in the past and "on schedule" if otherwise. The formula I have below is giving me a circular reference error. Current Formula: =IF(AND(Completed@row = 0, Finish@row < TODAY()), Status@row =…
Index Max / Children
Hello community, I need a formula that will return the most common value of its children. In the photo below. There are two expanded lists (Chatham and Patcham). I want my formula to capture the most common nature of issue for each location. In this example, Chatham should return 'Power Isolation Process' and Patcham…
INDEX COLLECT MAX
=INDEX(COLLECT({Nature of Issue}, {Nature of Issue Count}, MAX({Nature of Issue Count}, 1), {Site Name Helper}, Site@row), 1) Hello, community. I am trying to solve following. I want my formula (above) to return the nature of issue that has the most common nature of issue count for each site {Site name helper}. It is not…