The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Apr 02, 2019 06:57 AM
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
Apr 02, 2019 07:16 AM
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.)
Apr 02, 2019 07:30 AM
Thank you very much. I’ll do this. Thanks for your help!
Apr 02, 2019 07:33 AM
Perfect! Thank you again!