Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional formatting to ID identical fields

Topic Labels: Formulas
Solved
Jump to Solution
274 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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"
)

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!

This works! Thank you @ScottWorld!