+10I need some help trying to write a conditional formula...
The idea is IF any cell in column 1 is duplicative/match entry, then look at corresponding column 2 cells and merge merge into corresponding column 3.
Is if A2 and A45 match look at/merge B2 and B45 into C2 and C45
Is something like this possible?
+14What you describe is not really core functionality of Airtable, although it could be achieved with a relatively complex automation. It sounds like you might be making the mistake of thinking about Airtable as a spreadsheet rather than a database though. Can you describe the structure of your Base?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.