Formula to pull info. from one field or another

#1

Hi,
If I have three fields, ColumnA, ColumnB, and ColumnC. Either B or C will have text, not both.
Is there a formula I can use to have ColumnA populate with any text in ColumnB (and Column C is empty), if ColumnB is empty then ColumnA populates from ColumnC?

essentially trying to create ColumnA = ColumnB if not empty, If B is empty use C

Any help is greatly appreciated :slight_smile: Thanks, Pat

0 Likes

#2

You pretty much have the formula; you just need to change the wording slightly. :wink:

Here’s the formula for {ColumnA}.

IF(
    {ColumnB},
    {ColumnB},
    {ColumnC}
    )

Essentially, that says

IF(
    {ColumnB}, // exists, then make {ColumnA} equal to
    {ColumnB},
               // else if {ColumnB} does not exist, make {ColumnA} equal to
    {ColumnC}
    )

(Note: Airtable currently will not accept formulas with comments; instead, copy-and-paste the first version into the formula configuration field.)

1 Like

#3

Thank you very much. I’ll do this. Thanks for your help!

0 Likes

#4

Perfect! Thank you again!

0 Likes