Can we connect two “multi select” rows with each other?

[Dstep]

can we connect two “multi select” rows with each other? Example:
Column 1: A, B, C
Column 2: 1,2,3
We would like to associate A with 1, B with 2 and C with 3.

In a nutshell, what we’re trying to do is this: For each software developer in our database, we want to display the number of years they have in a specific technology. Say 5 years in PHP or 2 years in Airtable etc

Can this be done?

[Mohamed_Swella1]

Hi @Dstep,

You won’t be able to have a multi select field that changes, the field should be a Formula field. You can use this Switch({Coulmn1}, ‘A’, 1, ‘B’, 2, ‘C’, 3)

[Dstep]

That won’t work for us I don’t think because our values change. No other way eh?

[Mohamed_Swella1]

Hi @Dstep,

Please show me a screenshot of your current setup and maybe I have another solution. Maybe a Lookup Field?

BR,
Mo

[Dstep]

Hi Mohamed,

This is what I’m trying to accomplish.

Lightshot

Screenshot

Captured with Lightshot

[Mohamed_Swella1]

Hi @Dstep,

And how is your current setup? Screenshot your table.