Question

ArrayFormula Doesn't Copy after adding row

  • 12 October 2020
  • 1 reply
  • 52 views

Userlevel 1

I have a WooComemrce To Google Sheet Setup and I’ve added in a custom formula for a SKU system but unfortunately every time the Zapier automation runs it doesn’t copy or update the fields with the formulas.

Do I need to copy these formulas into the ZAP? 

 

I have Order Date (A2), Customer ID, Customer Name, Order ID and Product ID(E2) as fields pulled from WooCommerce with Zapier just fine.

 

Then I have two columns, SKY and Tracking 1 that are custom formulas that need to be added dynamically every time an order comes in.

 

=ARRAYFORMULA(IF(A2<>"",CONCATENATE(E2," ",SKUS!A1)," "))

 

When I add a new order this formula doesn’t copy like it would if I added it in Google Sheets.  How to I get Zapier to copy that formula and change it dynamically?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +8

Hi @Sixohm ,

Thanks for reaching out!

To make sure you receive the best assistance for this workflow, I suggest you contact our Support Team as they will be able to look at your specific configuration to troubleshoot!