How to we exclude a specific name from a DISTINCT LIST USER formula

Filippo ✭✭
edited 06/29/23 in Formulas and Functions

I would like to exclude a specific user name from this formula.

The formula is working fine, and it is returning a distinct list of user names. However, we need to exclude certain users, that are no longer in the group.

For example, how do I say to exclude user "Joe Black" from this list?

=IFERROR(INDEX(DISTINCT({Trial Lead}), [Unique Row ID]@row, 0), "")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!