How can I add rows from one sheet to another automatically?

Meghan Lundy

I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO.

 

So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice dollar amount. 

 

Does this make sense?? And does anyone have any ideas on how I can accomplish this?

 

 

Shaine Greenwood

Hello Meghan! It sounds like you're wanting a conditional move row (such that will move rows from one sheet to another), or possibly a form of the LOOKUP function that can look across multiple sheets—of which we have neither.

 

I know our Product team is hard at work on both features, but we don't have timeframe for when these will be released in the application.

 

In the meantime, you might consider looking at a service like Azuqua (https://azuqua.com/) that can facilitate a conditional move row for you.

J. Craig Williams

Meghan,

 

Zapier (www.zapier.com) is a cheaper (and less functional) alternative to Zapier.

It will satisfy your use-case, I believe. I have something similar running using Zapier.

 

Craig