Help

Re: Formula IF with emoji result

Solved
Jump to Solution
841 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Karola_Martinez
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

Captura de Pantalla 2022-08-29 a la(s) 12.03.03
Captura de Pantalla 2022-08-29 a la(s) 12.06.02

1 Solution

Accepted Solutions

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

See Solution in Thread

6 Replies 6

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

image

Karola_Martinez
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

Captura de Pantalla 2022-08-29 a la(s) 14.51.59
Captura de Pantalla 2022-08-29 a la(s) 14.57.02

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

Thankssss soooo much!!!