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!