If your Google Sheet contains formulas or scripts, our connected table may experience issues displaying data correctly. To avoid this, please follow the step-by-step guide in our documentation.
The main idea is to create a new sheet tab (or a completely new sheet) that is blank. Then, in cell A1, use the =IMPORTRANGE() function to import values from the original sheet once the formulas are complete. This will ensure that our table receives only the finished values, not the formulas.
This way, you can continue working on the original sheet with formulas and formatting, while our table will pull only the final processed values from the second connected sheet tab.
Please keep the column structure consistent at all times:
Do not remove or add any columns.
Do not rename any column headers.
If these guidelines are not followed, the connected table may break, and you will need to create a new one.