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.
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?