Skip to main content

Split multiple items in lookup field into separate text columns

  • April 25, 2022
  • 1 reply
  • 16 views

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!

1 reply

Forum|alt.badge.img+16
  • Inspiring
  • April 25, 2022

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.