Re: Formula Help

638 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I 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?

1 Reply 1

What 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?