
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 15, 2016 11:53 AM
Hi there!
Is there currently a way to filter the rows in a table by comparing two fields?
I’d like to only show rows where a value is not equal to the value of linked record. I am able to display them next to each other using a linked row, but the filter function seems to require a static value to compare with. Am I right on this?
Thanks,
Till

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2016 07:29 PM
Hi Till,
It’s currently not possible to set this up directly in the Filter menu, but there a simple workaround with one extra step:
- First, create a Formula field in the table, with the formula
Field1 = Field2
, using the names of the two fields you want to compare. To verify that this step was successful, the value should be 1 if the two fields are the same and 0 otherwise. - Filter the table to records where this new Formula field’s value is 1. That will filter it to only records where Field1 and Field2 are the same.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 23, 2016 06:48 AM
Hi Matt, I’m sorry to get back to you so late! I just wanted to thank you for reply, this works perfectly!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 18, 2020 12:21 PM
Nice workaround Matt… worked perfectly!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 07, 2021 11:31 AM
I have been using the suggested workaround. However, I wish you could specify the field as the comparator without having to add yet another field. Would be a nice feature … just saying.
