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?