Formula IF with emoji result

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

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}
    ),
    "✅",
    "❌"
)

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?

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

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?

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

Thankssss soooo much!!!