Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Combining field with a multiple select field

Topic Labels: Formulas
Solved
Jump to Solution
541 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.