IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)

JayRaditch

Hello,

I am trying to troubleshoot a formula to achieve the following outcomes.

Outcomes:

If the Due Date column is past today's date, trigger a flag in the "Past Due" column.

HOWEVER:

If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column.

Database Screenshot:

Current Formula:

=IF(AND([Due Date]@row < TODAY(), 1, 0), [Request On Hold]@row, false)

Paul Newcome

Give this one a go...

=IF(AND([Due Date]@row < TODAY(), [Request On Hold]@row = 0), 1)

Paul Newcome

Give this one a go...

=IF(AND([Due Date]@row < TODAY(), [Request On Hold]@row = 0), 1)

JayRaditch

Yes, this worked perfectly. Thank you Paul!

Paul Newcome

Happy to help! 👍️