- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2022 10:48 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2022 04:15 PM
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)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2022 12:09 PM
Hi @John_Dlouhy
Can you try this formula?
IF(Department, College&' and '&Department, College)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2022 04:15 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2022 08:00 AM
This worked like a charm! Greatly appreciated, Justin!
