Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Newton
Contributor III
Contributor III

Show value if it's exists in both fields

I have two fields with plenty of usernames and want to display [Field 1] values, but only if it's also exists in [Field 2], how can I do that?

Example:

[Field 1] [Field 2]
Name A Name C
Name F Name X
Name C  
Name O  

 

A table or chart that use [Field 1] shoud only display "Name C".

 

Labels (5)
1 Reply
Chanty4u
MVP
MVP

Here's an example expression that you can use to create a new field:

 

=if(Match([Field 1], [Field 2]), [Field 1]) as newfield