Skip to main content

I need a formula to populate a field based on three other fields - where only one will have data. So in fields 2 - 4 below, only one will have data and I want that to show up in Field 1.

 

Field 1 - formula

Field 2 - Lookup from table 1

Field 3 - Lookup from table 2

Field 4 - Lookup from table 3

You can use nested IFs in your formula. First check if the first field has a value, then if the second, etc.

 

This would look like this:

IF(
  {Lookup from table 1},
  {Lookup from table 1},
  IF(
    {Lookup from table 2},
    {Lookup from table 2},
    {Lookup from table 3}
  )
)

I'd love to explore more use-cases of Airtable and automation specific to your business, if you're interested feel free to book a free call at any time that works for you 🙂

-- Best, Milan - Automable.AI

Thanks! I was struggling with the nesting IF statements.

Happy to help! If this worked for you, please mark it as a solution so the thread will show as solved :)

Reply


Terms & Conditions