Skip to main content

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 🙂 Thanks, Pat

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

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!

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


Perfect! Thank you again!

Reply


Terms & Conditions