Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Function IF - AND - NOT?

Topic Labels: Formulas
1326 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Gdz91
4 - Data Explorer
4 - Data Explorer

Hello,

I am new to using Airtable.

I have a question about a formula I want to implement.

I would like to be able to do an IF function to check if a phone number is already assigned to the customer. If the phone number is assigned to customer 1, I would like to check if it is also assigned to customer 2, if so, a final check of the phone number for customer 3.

If the first condition is not validated, I would like to indicate “Customer1” in the result column, if the phone is assigned for “Customer1” but not for customer2, I would like the result column to indicate “Customer2” etc…

If the number is not in the list, and it is not assigned to any customer, I would like the result to be “Not assigned”.

The purpose of this formula is to check to which customer a phone number has already been assigned (knowing that it can be assigned to several customers).

This formula would be used during an API connection to check for a defined phone number and assign it to a customer who does not already have that phone number in his database.

If you have any idea about that, you would be a great help to me!

Thank you

2 Replies 2

Hm so each record contains the phone numbers of 3 customers?

Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

Hello,
The first question is how your base would be designed to track this information. From your description I am thinking you would have two tables: PhoneNumbers and Customers.

The PhoneNumbers table would include 3 columns (customer1, customer2, customer3) that each Link to a single value from the Customers table.

You could then create a formula column using nested IF formulas like this:

IF({Customer1},
   IF({CUSTOMER2},
      IF({CUSTOMER3},
         "Fully Assigned",
         "Customer3"),
      "Customer2"),
   "Customer1"
)

The resulting behaviors would look like this
image