Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
Here's an example expression that you can use to create a new field:
=if(Match([Field 1], [Field 2]), [Field 1]) as newfield