+8I 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
Best answer by Milan_Automable
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
+11You 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
+11Happy to help! If this worked for you, please mark it as a solution so the thread will show as solved :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.