Looking to auto populate red flag for overdue invoice

Staci Belonos

Im having trouble figuring out a formula to create a flag in the overdue column when the due date is in the past and the status is pending or delayed. Flag needs to disapper once status changes to paid

Picture for reference

Paul Newcome

Try this:

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

Paul Newcome

Try this:

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

Staci Belonos

Is returning an invalid message

Paul Newcome

Invalid what exactly? There are a few errors that start with Invalid.

Double check that the [Due Date column is in fact set as a date type column. If it is, how exactly is that column being populated?

Staci Belonos

Oh that worked I changed it to date type.

Thanks so much for your help!!!

Paul Newcome

Happy to help. 👍️