How to keep formulas from being erased in my Google Sheet in cells where no new data is being added?

Question

Hi,My zap transfers new data from my Wix site to a Google Sheets spreadsheet where a new row is created with data in columns, for example, A:D. So the zap triggers and A2:D2 now have new information.I entered some formulas in my spreadsheet in columns, for example, E:F that depend on the data from A:D. So if a zap triggered and A2:D2 had new information, then the formulas in E2:F2 should change according to the new information. But my formulas in columns E:F are erased. The zap then triggers for A3:D3 and E3:F3 should reflect the new information but they’re also erased and this happens successively for each row.I know that I can fix this my manually entering my formulas in my zaps but it will take a LONG TIME to complete this. Is there a shortcut towards achieving this?

Troy Tessalone · Answer

Hi@irving.modabeaBetter approach might be to use formulas on another tab to pull thru the data from the master tab then apply the desired formulas.Try using these formulas:FILTER: https://support.google.com/docs/answer/3093197?hl=enQUERY: https://support.google.com/docs/answer/3093343?hl=enARRAYFORMULA: https://support.google.com/docs/answer/3093275?hl=enAlso, make sure to check the available help docs, about how to structure a GSheet to work with a Zap as well as known limitations: https://zapier.com/apps/google-sheets/helpAnother alternative would be to use Airtable instead of GSheets.Airtable has a Formula field: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-referenceNOTE: Depends on the complexity of your formula.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded