Split text cell into various records for linked lookup formula

Hello All,

I am trying to convert a concatenated text cell into various records, split by the semi-column.
image

Ideally, an automation would somehow split the cell contents so I can return the linked lookup value for both Optimisers, and Double Storey and their relevant costs in another lookup column.

Is there a way I can split the contents into separate records for the pricing data column?

Hi @Luca_Wessels ,

Just to confirm, you’d like to end up with the following, is that right?

Screenshot 2022-08-26 at 1.15.04 PM

If so, if you split your text by a comma instead of a semi-colon, you can paste that text into the Pricing Data linked field and it would become separate records based on the comma split automatically

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.