Past Due Calculation

spulerj

Hello - I'm trying to build a formula to calculate if a row item is past due based on a value in a due date field. The columns with data are: Approved/Declined Date and Past Due Date. I'm looking for the formula to calculate if Approved/Declined Date is blank and after the Past Due Date to come back with a value of True.

Any help with the above would be greatly appreciated. Thank you!

Jeff

Paul Newcome

Try somethign like this:

=IF(AND([Approved/Declined Date]@row = "", [Past Due Date]@row < TODAY()), 1)

Paul Newcome

Try somethign like this:

=IF(AND([Approved/Declined Date]@row = "", [Past Due Date]@row < TODAY()), 1)

spulerj

That worked, thank you Paul!

Paul Newcome

Happy to help. 👍️