Greetings everyone,
I am working on creating a spreadsheet for invoices where certain projects are billed to our clients in tiers based on completion. I set up a column to determine if the invoice was split. This works fine, but I would like the column next to it to display which invoice contains the rest of the project payment. Do you have any recommendations for locating and taking action on the next time the project comes up, as well as locating the invoice that it is under?
I am working on creating a spreadsheet for invoices where certain projects are billed to our clients in tiers based on completion. I set up a column to determine if the invoice was split. This works fine, but I would like the column next to it to display which invoice contains the rest of the project payment. Do you have any recommendations for locating and taking action on the next time the project comes up, as well as locating the invoice that it is under?