Help

Re: Formula to pull info. from one field or another

948 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Patrick813
5 - Automation Enthusiast
5 - Automation Enthusiast

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

3 Replies 3

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

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

Perfect! Thank you again!