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?
Automation won't allow Google sheets Automations to work
+1
+6If 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.
+1If 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.
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
+6I 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
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:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.