Help

Conditional formatting to ID identical fields

Topic Labels: Formulas
Solved
Jump to Solution
1007 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Dena_Mendelsohn
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to create an airtable column that will say Yes if two other columns are identical, say No of those other columns are not identical, and say N/A if one of the columns is empty. Is there a way to do this?

For example:
Column A says Cow
Column B says Cow
So conditionally formatted Column C says Yes

Column A says Cow
Column B says Duck
So conditionally formatted Column C says No

Column A says A
Column B is blank
So conditionally formatted Column C says N/A

I’ll take any solution, doesn’t have to be conditional formatting.

Thanks ahead!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Dena_Mendelsohn! :slightly_smiling_face:

This formula should work for you:

IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Dena_Mendelsohn! :slightly_smiling_face:

This formula should work for you:

IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)
Dena_Mendelsohn
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks @ScottWorld! If my columns are actually sentences (rather than “A” or “B”) do I just put the sentence column name in {brackets}? Very much appreciate your help on this!

Yes, that’s correct!

Dena_Mendelsohn
5 - Automation Enthusiast
5 - Automation Enthusiast

This works! Thank you @ScottWorld!