Formula IF with emoji result

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?


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?

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?


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

Thankssss soooo much!!!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.