HiI would like to compare 2 text fields. The first in "Internal" and the second is "External".I saw this solutionhttps://community.airtable.com/t5/formulas/comparing-of-two-values-in-rolled-up-fields-and-showing-true-if/td-p/61679IF( ARRAYJOIN({Inter...
Hi, I have two tables in a Database.One table: called "People". It has list of peoples and their Emails.Second table: called "Mailing" Has email from table one.I would like to set an new field in "People" (table 1) that marks "1" if an email is prese...
Hi JamesThank you but in case one or more of the fields is not plan text then I won't work since apperentaly Airtable does not see Lookups as texts but as references.A solution is to add CONCATENATE before the lookup field. IF(CONCATENATE(LOWER({Inte...
I found the solution.The prolem seems to be that Airtable doesn't store lookup fiels as text (the internal was not text but lookup)so this is the solution:IF(SEARCH(LOWER(CONCATENATE({internal})),LOWER(external)),"Good","Not Good"). CONCATENATE({inte...
