For some reason this is pulling everything out of order for me? My 'fruit' multi-select column is called "OLC" and example three options are S6TO, S63, and S65, and the formulas above end up pulling OLC 1 as S63, OLC 2 as S65, and OLC 3 as S6TO. Where I need it to pull showing OLC 1 as S6TO, OLC 2 as S63, and OLC 3 as S65. I am wondering if it has anything to do with it trying to put things in alphabetical order? Is there a way I can make sure it pulls in order that I actually have the multi-select list created? We need the list to be a specific order (which isn't alphabetical) for clients utilizing a form and needing to see their course options in that specific order. And these helper columns are utilized in other formulas and automations so need to be in order they are selected to work properly
@smartsheetguru
6 ай бұрын
What's the order of the columns in your formula?
@Nicole-c1y2j
6 ай бұрын
@@smartsheetguru so my columns as they match to yours are [Fruit Multi Select] = [OLC] [Quantity Fruits Selected] = [# of OLCs Selected] [Fruit 1] = [OLC 1] [Fruit 2] = [OLC 2] [Fruit 3] = [OLC 3] And the multi select options in the order I need them are: SIE S3. S4. S6TO S7TO S9. S10 S24 S31 S34 S63 S65 S66 S99TO
@victorgentile3999
2 жыл бұрын
This doesn't seem to work for a contact list. Any work arounds?
@smartsheetguru
2 жыл бұрын
Victor, multi contact column entries are separated by a comma space, so you would need to search for ", " instead of char(10).
@DYNAMMIC-
2 жыл бұрын
Can you provide me with examples of formulas if we were to use 5 Selections instead of just 3?
@smartsheetguru
2 жыл бұрын
I could help you write the formula if you'd like. Visit www.smartsheetguru.com/contact/ if you want to arrange some time for me to help and I'll reply with a quote.
@Ckola775
2 жыл бұрын
For what it’s worth this is absolutely the wrong way to approach this problem. I was hoping someone else worked out the text parsing but I ended up spending 2 hours working it out in front of my boss for 15 option parsing. Lmk if you still need help.
Пікірлер: 8