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 rateI need Unpaid sheet to pull information IF invoice is unpaid and then pull the relevant information.  Is this possible?
Google Spreadsheet Lookup question?
google spreadsheets