Copy formula to Google Sheets with Zapier while keeping the correct cell reference
Budget: €30 – €250 EUR
Need to copy a formula to Google Sheets using Zapier
We have a Zap which loads Woocommerce orders to Google Sheets. We need to copy some formulas as well while keeping the correct row reference.
For example, formula =track(V2, "status", false, $B$2)- Zapier is uploading it to Row 99, and we should have =track(V99, "status", false, $B$2).
We have a Zap which loads Woocommerce orders to Google Sheets. We need to copy some formulas as well while keeping the correct row reference.
For example, formula =track(V2, "status", false, $B$2)- Zapier is uploading it to Row 99, and we should have =track(V99, "status", false, $B$2).