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?