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

Identifying oldest entry on sheet, for different groups
Hello! I am working on a "waitlist" process, where the sheet will have multiple candidates under each work location. I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. Example…
Week Over Week Change
I have a sheet that has orders entries from the last 6 months. This sheet continues to populate as more orders are made. This is just my repository sheet. I am looking to get the week over week change metrics for the last 7 days. Here's the formula that can provide me that week over week change: Week over week %% =…
Trying to complete an INDEX MATCH formula
I am trying to create an INDEX/MATCH formula and the criteria used between the sheets for MATCH is: Sheet 1: First Name and Last Name in one column Sheet 2: Has 2 columns: first name and Last name I've tried to write a formula to combine the names on sheet 2 =[First Name]@row + " " + [Last Name]@row I've written many…