Pulling information from one table based on Single...

[Patrick813]

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 :slightly_smiling_face: Thanks, Pat

[W_Vann_Hall]

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

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.)

[Patrick813]

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

[Patrick813]

Perfect! Thank you again!