
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2019 07:30 AM
Thank you very much. I’ll do this. Thanks for your help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2019 07:33 AM
Perfect! Thank you again!
