Help

Formula for Combining Multi-Select Fields

Topic Labels: Formulas
Solved
Jump to Solution
1444 3
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Dlouhy
7 - App Architect
7 - App Architect

Greetings Airtable Community,

I am seeking help with formatting the formula below that combines data from two multi-select fields:

{College}&" and "&{Department}
Example of what the formula returns: Humanities and Department of Religion

{College} is always be populated, but {Department} is sometimes empty.
When this is the case, the formula returns: Humanities and

Is it possible to edit the formula so that if {Department} is empty, the " and " will be removed, returning just the name of the College?

Thank you very much!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Here’s an alternate way to write it. Because the college name will always be in the result, there’s no need to include it in the condition, as that only relates to the department.

College & IF(Department, " and " & Department)

See Solution in Thread

3 Replies 3

Hi @John_Dlouhy
Can you try this formula?

IF(Department, College&' and '&Department, College)
Justin_Barrett
18 - Pluto
18 - Pluto

Here’s an alternate way to write it. Because the college name will always be in the result, there’s no need to include it in the condition, as that only relates to the department.

College & IF(Department, " and " & Department)

This worked like a charm! Greatly appreciated, Justin!