Formula IF with emoji result

[Karola_Martinez]

Hello community I was wondering if you could help me.

I want to make a formula that shows me the emoji “ :white_check_mark: ” if the names and emails are in the contact fields, otherwise it shows me “ :x: ” but I don’t know what I’m doing wrong in my formula.

Could you help me?

[Mohamed_Swella1]

Hi @Karola_Martinez ,

Welcome back to Airtable Community

it is actually a very simple solution, you have an additional bracket in the formula before the “({Nombre (from Main Contact) (from Corporaciones)},” remove that bracket and it should work fine

[Ben_Young1]

Hey @Karola_Martinez,

Wanted to hop in on this real quick.

The field names are intense, so excuse my changes, but I’m curious if this formula gets you what you’re looking for.

If it does, then you can just switch in your table’s field names.

IF(
    AND(
        {Nombre},
        {Correo Electrónico}
    ),
    "✅",
    "❌"
)

[Karola_Martinez]

Mohamed_Swellam:

({Nombre (del contacto principal) (de Corporaciones)}

Thanks for the suggestion! I did but it still doesn’t work.

It gives me an email as a result but not the emoji I want.

What I want is that if my fields “Entrepreneur Name”, “Email Entrepreneur”, “Corporation Leader Name” and “Corporation Mail” are not empty, then I get the formula “ :white_check_mark: ” and if the complete fields or some is empty I get “ :x: ”

I changed the name of the fields to make it easier.

Could you help me?

[Karola_Martinez]

Thanks for the suggestion! I did but it still doesn’t work.

It gives me an email as a result but not the emoji I want.

What I want is that if my fields"Nombre Emprendedor", “Mail Emprendedor”, “Nombre líder corporación” y “Mail Corporación” are not empty, then I get the formula “ :white_check_mark: ” and if the complete fields or some is empty I get “ :x: ”

I changed the name of the fields to make it easier.

Could you help me?

[Ben_Young1 · Accepted solution]

Karola_Martinez:

What I want is that if my fields"Nombre Emprendedor", “Mail Emprendedor”, “Nombre líder corporación” y “Mail Corporación” are not empty, then I get the formula “ :white_check_mark: ” and if the complete fields or some is empty I get “ :x: ”

Ah, in order to achieve this, you’ll just add the additional field to the AND function parameters:

IF(
    AND(
        {Nombre Emprendedor},
        {Nombre líder corporación},
        {Mail Corporación}
    ),
    "✅",
    "❌"
)

[Karola_Martinez]

Ben.Young:

IF(
    AND(
        {Nombre Emprendedor},
        {Nombre líder corporación},
        {Mail Corporación}
    ),
    "✅",
    "❌"
)

Thankssss soooo much!!!