This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Split multiple items in lookup field into separate text columns

Topic Labels: Formulas
191 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mike_Tullo
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Apr 25, 2022 07:16 AM

Hello!

I am looking to add a formula that would split this lookup field that can contain multiple items and separate or split into separate text columns for each “planning unit”. The planning unit column can have no items or up to 10ish items.

Thanks in advance for the help!

Screen Shot 2022-04-25 at 10.13.25 AM

Reply
1 Reply 1
Vivid-Squid
11 - Venus
11 - Venus
See Solution in Thread

‎Apr 25, 2022 11:25 AM

Hi @Mike_Tullo
I do not think that you can create new fields with a formula or with scripting. With Scripting you can however extract all of the names of items in the linked field.

0 Kudos
Reply
Copyright © 2023 Khoros, LLC