- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 28, 2016 10:22 PM
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() ))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 29, 2016 04:50 PM
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.