Help

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.

Combining field with a multiple select field

Topic Labels: Formulas
Solved
Jump to Solution
1296 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Molly_Hyde
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to combine a linked field containing a job title with each item in a multiple select field, which contains different statuses and sub-statuses in the application process. Ultimately, I need to be able to keep track of each status that a candidate has ever been in. I’m using the simple formula below:

{Job Title} & "_" & Status

But it seems like Airtable treats the different items in the multiple select field as an array. The formula produces the job title followed by a string of each of the statuses separated by a comma.
airtable calculation

I’d like for it to produce the different combinations - Job F_1.a, Job F_2.a.

Does anyone know how to do this?

1 Solution

Accepted Solutions
Molly_Hyde
5 - Automation Enthusiast
5 - Automation Enthusiast

Was able to modify this solution for my purposes.

See Solution in Thread

1 Reply 1
Molly_Hyde
5 - Automation Enthusiast
5 - Automation Enthusiast

Was able to modify this solution for my purposes.