How to filter on AND + OR statements

acunningham95401

Hi all,

Please see what we are trying to achieve below.

I have hit a wall and wanted to get some feedback.

(a)   Not complete, and

a.      In the past, or

b.      In the next 30 days'

Thank you!

Paul Newcome

Whenever a column name has a space, number, and/or special character in it, the column name must be wrapped in square brackets [ ].

=IF(AND(Status@row <> "Complete", [Due Date]@row <= TODAY(30)), 1)

Paul Newcome

You could add in a checkbox column and use a formula such as below to check the box for rows that match the criteria.

=IF(AND(Status@row <> "Complete", [Date Column]@row <= TODAY(30)), 1)

Then you can filter on this checkbox.

acunningham95401

Hi Paul,

This may do the trick! However, I may be copying this incorrectly. I am getting the UNPARS error.

I have the [Date Column] referencing our "Due Date" column. Any ideas what could be causing this. I have tried to rework it but am not having any luck.

Paul Newcome

Can you copy the formula directly from the sheet and paste here?

acunningham95401

=IF(AND(Status@row <> "Complete", Due Date@row <= TODAY(30)), 1)

The columns referenced are Status and Due Date

Thank you!!

Paul Newcome

Whenever a column name has a space, number, and/or special character in it, the column name must be wrapped in square brackets [ ].

=IF(AND(Status@row <> "Complete", [Due Date]@row <= TODAY(30)), 1)

acunningham95401

Thank you!!

Paul Newcome

Happy to help! 👍️