Find Overdue Unpaid Invoices Automatically in Google Sheets

Look at this example. Some invoices are paid. Some are unpaid, but their due dates are still in the future. We only want rows that pass both checks.

Our source is A two through D nine. Column B contains payment status, and column C contains real spreadsheet dates. Copy the headers to an empty area, then click F two.

Start with FILTER and the full source range. Add column B equals Unpaid in quotation marks. Then add column C less than TODAY, with empty parentheses. Keep every range the same height.

Press Enter. In this example, three invoices qualify: one oh one, one oh four, and one oh seven. Paid invoices and future due dates stay out of the result.

When a payment status changes in the source, FILTER recalculates the output. TODAY uses the current date when the sheet recalculates. This is a spreadsheet list, not an automatic payment reminder.

Use real dates, not text that only looks like a date. Keep the output area clear. Extend all the ranges when you add more invoices. If nothing matches, FILTER returns an N A error; that does not mean a payment is missing.

You can use the same two-condition idea for tasks or orders. Which list would you like to automate next? Tell me in the comments.