I inherited a sheet that I'm trying to redesign. We have multiple purchase orders (PO) with multiple invoices applied to each PO. Once an individual invoice is paid by accounting, we want to mark the row "complete" and move the row to an archive sheet. The PO needs to continue to reside on the original sheet so that additional invoices can be applied to it.
I've thought of having a master sheet with reports that filter on current information.
I have searched Smartsheet templates but have not found any that meet my needs. Any ideas out there in the community?