How to convert a lookup column to a multiple-select column

Hi everyone !

I’m using the lookup tool but i want to know if it’s possible (maybe with a formula) to convert what’s inside the lookup column into a multiple-select column ?

Thank you !

Change the field type from Lookup to Multiple Select. Airtable will maintain the existing data, and just change the way that data is selected via the new field type.

1 Like

But will it continue to lookup data ?

No. You asked how “to convert what’s inside the lookup column into a multiple-select column,” which sounded to me like you wanted to permanently switch the field type from one to the other.

A field can only be a single type. It can either be data that you create/choose (single/long text, number, currency, single/multiple select, etc) or it can be pulled/calculated based on data elsewhere in your base (lookup, rollup, formula, etc). It can’t do both things at once.

Could you describe in more detail what you’re trying to achieve, and the current setup of your base and tables?