Announcements
Hi all,
I'm creating a view for a table that contains two lookup fields connected to users: Requested by, Created by (internal field).
I want that view to show items where the user is either the "Requested by" or the "Created by" in the advanced filter box but I'm not finding the right way to do it because the default value is "And" and related tables apparently cannot be grouped in the filter.
Any ideas?
Hi @ReneAlvarezM
Check both boxes
Select the group OR
Select the OR on the left side
I can select "Or" when using simple columns but not with "Lookup" columns.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 258
Mohsin Ali 231