Needing some help with google sheets. SO I have a sheet named 2016 with invoices listed and information on them within that row. I need a new sheet named "unpaid" to pull all of the unpaid invoices.
Lets say the column reads (column title for A, B, C...):
Invoice date, Invoice #, Paid/unpaid, Invoice Amount, Brokerage rate
I need "Unpaid" sheet to pull information IF invoice is unpaid and then pull the relevant information. Is this possible?