Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Importing Data into Existing Table w/Formulas, etc.

Topic Labels: Importing & Exporting
344 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Wendy1
4 - Data Explorer
4 - Data Explorer

All:

I have imported data from an excel into an existing table in a base.  The existing table is called "Income Account Transactions."  There is another table called "Profit & Loss" that links to Income Account Transactions table. It  calculates data from the table.  The imported data is not calculating into the Profit & Loss Table.  What am I doing wrong?

3 Replies 3
SabtainSaleem
4 - Data Explorer
4 - Data Explorer

Importing data into an existing Airtable table with formulas can be tricky. The key is to ensure that the structure of the data being imported matches the existing fields. If your data includes formula-based columns, you'll want to double-check that formulas are correctly configured post-import to ensure they work as expected. Using CSV files or third-party tools might streamline the process.

Could you provide screenshots of both tables with the relevant fields, specifically the linked field between the tables? 

If you could provide a read-only invite link to a duplicated copy of your base with no records in it I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable

Workflow_heroes
5 - Automation Enthusiast
5 - Automation Enthusiast

Just to understand your question, because there is a difference in excel vs airtable in the way the relation between tables work. Also importing can sometimes cause a few hiccups. 

  1. Can you double check that the fields you are trying to use formulas on are numbers/currency not single line text?
  2. How are you referencing with the formulas the values that are in "Income Account Transactions"? Have you created a linked field and then looked up (or rolled up) the values you require in the table called "Profit & Loss"? Because you can't reference fields from other tables if they are not linked and looked up first.