Google Sheets Using Formulas with Automatic Updates Enabled

When automatic daily updates are enabled, the google sheet will not keep your custom formulas. Here is a workaround.

Written by Martin Leclair
Updated on February 12, 2024

If you are using custom formulas for analysis on the main google sheet that is exported using the google sheets export tool, your formulas will not be saved when an automatic update is done.

You should create a separate spreadsheet where you analyze the data from the Google Sheet Export file from Wealthica. To do so, on your own spreadsheet, use the function "IMPORTRANGE" (https://support.google.com/docs/answer/3093340?hl=en).

With IMPORTRANGE you can import the sheet from the sheet URL into your own spreadsheet. Then you can do all your manipulations from your own spreadsheet.