IF Find Formula

You’re missing a closing parenthesis after your FIND function.

Extracting just your final IF statement, it should look like this:

IF(FIND("X", {COLUMN A}), "X")

Hi @ScottWorld thanks for looking into this and for your reply.
Sorry but there was a typo when I copied and pasted the formula. To make things clearer, I have created a base: Airtable - Grid view

What I would like to achieve is:

1. If reseller email cell is empty and customer email is populated, the value in reseller or direct should be the same as the customer email cell.
2. like 1 but inverted
3. if a specific string of text is contained in the reseller email, the value should be the string

3 works if I don’t add the other IF conditions but I have no idea why the whole formula doesn’t.

This is the formula I am using:

IF({Reseller Email} = BLANK(), “Direct Order”, IF({Customer Email} =BLANK(), “Reseller Order”, IF(FIND(“resellername”, {Reseller Email}), “Reseller Name” )))

Thanks

Instead of making those fields equal to BLANK(), make them equal to "".

HI @ScottWorld,

Thanks for your follow up. Unfortunately, I am still not getting the desired outcome:

If I use this formula:

IF({Reseller Email} = " ", “Direct Order”, IF({Customer Email} = " ", “Reseller Order”, IF(FIND(“resellername”, {Reseller Email}), “Reseller Name” )))

The IF(FIND(“resellername”, {Reseller Email}), “Reseller Name” ))) part works but the first IFs don’t.

If instead I use this formula:

IF({Reseller Email} = “”, “Direct Order”, IF({Customer Email} = “”, “Reseller Order”, IF(FIND(“resellername”, {Reseller Email}), “Reseller Name” )))

The first 2 conditions work but the last one doesn’t.

Basically the only difference between the 2 formulas is that in the second one there is no space between the quotes ("") and in the first one there is a space (" ")

Would you have any idea, please?

Glad I could help, and glad you figured it out! :slightly_smiling_face: