@Lauren_Bell, it should be possible to use AND/OR logic with collaborator fields. Can you show me your formula and describe why it’s not working / what it is returning? Perhaps we can get it working.
Hi Jeremy, thank you for replying. Essentially, this is what I’m trying to see in the same view with my Airtable:
- See all records where I’m marked as Owner AND filter out any record marked as Completed
- OR See all records where I’m marked as a Collaborator AND filter out any record marked as Completed
According to the Support article I found, this is not possible to setup within the Airtable filters because it won’t know what order of operations to do since I can’t structure it like how I did as above. I can only do OR or AND logic, not both at the same time.
Hi Jeremy, thank you for replying. Essentially, this is what I’m trying to see in the same view with my Airtable:
- See all records where I’m marked as Owner AND filter out any record marked as Completed
- OR See all records where I’m marked as a Collaborator AND filter out any record marked as Completed
According to the Support article I found, this is not possible to setup within the Airtable filters because it won’t know what order of operations to do since I can’t structure it like how I did as above. I can only do OR or AND logic, not both at the same time.
@Lauren_Bell
You’re correct that it can’t be done with only filters, since you can’t mix OR and AND filters.
But what you can do is create a formula field that checks whether you are marked as either Owner or Collaborator, and use that as your Filter field - this way you can incorporate both OR logic and AND logic in your filter.
So create a new Formula field (perhaps called {Lauren's Task?}
, and give it this formula:
IF(
OR(
Owner = "Lauren Bell",
Collaborator = "Lauren Bell"
),
TRUE()
)
And then set your filter to show you records where {Lauren's Task?} = 1
AND {Completed} = False
.
Thank you so much Jeremy! This helped me tremendously.
Thank you so much Jeremy! This helped me tremendously.
You’re welcome
__