I’m looking for help to write a formula that will help filter records that meet these requirements. I can’t seem to get it done using the filter function.
Where date is within the next week
Where date is within the last 3 days
Where check box is not marked
Hi and welcome to Airtable!
Do you mean literaly within the next week, like within week 39 now, or do you mean within the next 7 days?
DATETIME_FORMAT(Date, 'W') = DATETIME_FORMAT( DATEADD(Today(), 1, 'weeks') , 'W'),
IS_AFTER(Date, DATEADD(Today(), -4, 'days')),
Checkbox = 1
"Don't meet criteria"
Thank you so much - I actually figured out a way to force it to work by reordering the filters!
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.