Help

If Statement changing content in another field

3813 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Cinematic_Pictu
4 - Data Explorer
4 - Data Explorer

Is it possible to create a formula something like this:

IF({Fulfillment Company}=“Thomson Shore”, {Thomson Shore Ref}={Shipping First & Last Name})

So Field A is being used as a formula field if Field B (multiple option) says X (an option) then Field C (link to another record) will pull information from Field D (normal text field).

5 Replies 5
Phil_Lauer1
4 - Data Explorer
4 - Data Explorer

I’d like to be able to do something similar, change the contents of a text field based on data in another field. Any luck accomplishing this?

Unfortunately not - would love to hear a response from Airtable.

It is not enough with Formula and Lookup fields? Could you explain or leave an example?

To expand on @Elias_Gomez_Sainz’s response:
If you have your data structured like so:

  • Table: Companies
    • Field: Company Name
    • Field: Contact Name
  • Table: Invoices
    • Field: Fulfillment Company
    • Field: Shipping First & Last Name

You can look up the data you need by linking {Fulfillment Company} to “Companies”, and setting {Shipping First & Last Name} to a lookup field ( {Fulfillment Company} > {Contact Name}).

This is the related official help page:

35993329756e2b10043be2563e3f1326ef29799e.png

Linking Between Tables - Airtable Guide

With Airtable, you can create relationships between individual records.  Building on our Martian example, we can connect our Mars supplies with the vendors that manufactured them.  This will display the name of the vendor in-line and make it easy to...

Cinematic_Pictu
4 - Data Explorer
4 - Data Explorer

The lookup fields work well for some things. Here’s a more detailed (and clearer) example:

Column A.1 - Sheet 1 - Formula Field
Column B.1 - Sheet 1 - Multiple Option Field
Column C.1 - Sheet 1 - Link Field to Sheet 2
Column D.1 - Sheet 1 - Link Field to Sheet 3
Column E.2 - Sheet 2 - Text Field
Column F.3 - Sheet 3 - Text Field

If Column B.1 is “Value 1”, then Column A.1 would populate information from Column E.2
BUT
If Column B.1 is “Value 2”, then Column A.1 would populate information from Column F.3
AND
It’s still editable for custom values

So the information would all be in one column, instead of having a formula per column.