Help

Split text cell into various records for linked lookup formula

Topic Labels: Formulas
417 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Luca_Wessels
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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