filterByFormula with OR nested inside AND


#1

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() ))


#2

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

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.