I have a Google Spreadsheets with several sheets. I have it set up to where orders auto populate three of these sheets when entered into the Order info page.
I need to set up a function where only order numbers with a certain suffix (e.g.
WVCHA1234-TWC) also auto populate another sheet within the same spreadsheet. I don't need all orders in this sheet, just ones ending in
Is there a formula I can use for this?