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"
