May 02, 2021 04:21 PM
I have an airtable table that I have automated into a Google sheets sheet, and then have that google sheets sheet copying info to another google sheet using the =Sheetname!cell number formula, but nothing appears when I have the airtable automated data in there, only when I type it manually into the google sheet. How can I fix this? is the data formatted differently when it comes from Airtable, or does the google sheet not recognize it is there or something in order to add it to the second sheet?
May 02, 2021 04:51 PM
If your google sheet forumla is referencing a specific cell; check if the cell reference is changing when a new row from airtable is added.
I know most apps when they add a row of data to google sheets do it by effectively ‘inserting’ a new row; pushing all the existing cells (and cell references) down by one row.
If you are trying to copy/link/sync all the data from one google sheet to another; look into using the “IMPORTRANGE” function instead.
May 03, 2021 04:08 PM
I just do one section at a time and then erase the data, so the linked cells don’t need to change, it just won’t recognize the data for some reason
May 03, 2021 07:46 PM
Sorry I don’t understand what you are seeing; If you post a few screenshots we might be able to help you better :slightly_smiling_face: