Skip to main content

Hi!

I am new to Airtable - and it shows a lot of promise but I have a hard time wrapping my head around it.


I need to check my orders against a backorder list.

I can get both as excel files and thus read them into Airtable.

Then I need a crosssection of the columns.

Something like:

For every_line in ColA (for every_line in ColB check if ColA_item = ColB_item → return ColB_item)


Does this make any sense? 🙂


Are you importing two different Excel files/sheets into one Airtable table? Depending on what your data looks like that might not be best practice.


But to answer your question directly, to compare the value of {ColA} to the value of {ColB} for each record, crate a Formula type field with this formula:


IF(

   {ColA} = {ColB},

   {Col B}

)

Reply


Terms & Conditions