Help

Re: filterByFormula with OR nested inside AND

1186 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m attempting to find a list of specific records that also meet other criteria, such as a date—however nothing is returned.

AND( IS_BEFORE({Start Date},TODAY()), OR(RECORD_ID()=‘recyZ1f0RSR1rTr3Z’,RECORD_ID()=‘recIFWsWuTPjAkxhg’))

Is it possible to nest a OR inside an AND? Is there another way I’m not thinking of?

AND( TRUE(), OR( TRUE(), FALSE(), FALSE() ))

1 Reply 1

Soooooo, yeah. This works totally and completely fine. Assuming you have records that match :slightly_smiling_face:

I needed to swap the order of the IS_BEFORE parameters because I was wanted to ask, “is TODAY() before {Start Date}”, not the other way around.