Collect Formula

Susan van Niekerk

Hi Brain Trust

I am after a Collect formula or something…………

I have a column that is being populated by a Datashuttle so have been unable to make it a drop down ( Datashuttle wont run if it is assigned as a dropdown) It is returning various selections ( from the Source)

I need to separate this data into relevant Columns, extracting with formulas.

So for example - IF PPE Sizes Contains "Boots Men" then return that "Boots Men 4"

Kelly Moore

Hey @Susan van Niekerk

I'm happy to help. To clarify, are you trying to parse you PPE Sizes column into a Boot column, Jacket column, pants column and Shirt column? That is, split up the text into different columns?

If yes, would you first try to word wrap that column?- you might need to make the column skinnier to see if it will wrap. I would like to see if any line break characters carried over from your excel file.