Skip to main content

Formula to pull info. from one field or another

  • April 2, 2019
  • 3 replies
  • 53 views
P
Forum|alt.badge.img+3

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

    This topic has been closed for replies.

    3 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • April 2, 2019

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

      P
      Forum|alt.badge.img+3
      • Patrick813
      • Author
      • Known Participant
      • April 2, 2019

      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!

      P
      Forum|alt.badge.img+3
      • Patrick813
      • Author
      • Known Participant
      • April 2, 2019

      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!

      Terms & ConditionsAccessibility statement