Forum Discussion

karthiga's avatar
karthiga
Qrew Trainee
2 months ago
Solved

Combining Multiple Text Lists into One Text list Field

I have three text lists as input: List A = [A, B, C] List B = [E, F] List C = [G, H] I want to combine these into a single text list as output, like this:[A, B, C, D, E, F, G, H] The output fiel...
formulas
  • Paul_Hinzman's avatar
    Paul_Hinzman
    2 months ago

     Split(List(";",ToText([List A]),ToText([List B]),ToText([List C])))

karthiga's avatar
karthiga
Qrew Trainee
2 months ago

Thanks for the response.

This solution would be suitable if the list had a fixed number of items. However, in my case, the list is dynamic, and the number of items in lists can vary. Do you have any suggestions for handling this scenario?

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

I'm not understanding what the problem is. That formula would combine list with up to 20 choices selected. 

Because you have three fields, you would have to first combine two of the fields and then combine that combined field with the third field so you probably would use two separate formula fields