I’m stuck on an IF-formula and hoping someone can help me out.
I have two fields;
- A Lookup from another table
- A Multiple select
IF the Multiple select field is showing the same as the Lookup, I want an IF-formula to output “something”.
Lookup: Done, Done, Working, Working
Multiple select: Done, Done, Working, Working
IF-formula output: “Identlical”
Lookup: Working, Working, Working, Working
Multiple select: Done, Done, Done, Working
IF-formula output: “Not identlical”
Very simple IF-formula: IF(Lookup=Multiple select,“Identical”,“Not identical”)
My problem is that the IF formula always shows the two fields as “Not identical”, no matter what’s the input in the Multiple select.
I have a theory that although the two fields looks to show the same, Airtable reads them differently (commas, spaces etc). With this in mind I have also tried to “translate” the two fields with a concatenate formula, but with no luck.
Any ideas out there?