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!
