Forum Discussion
Solved
Multiple text search
Dears, I hope you all are doing well! I have tasks that are applied to multiple users. I have to count the tasks by user and filter it by user too. I splitted the users by the separator ...
Hi rdgbasilio ,
I splitted the users by the separator "," but it generated too much collums.Did you splitted your table as below? This may casue too much columns in your new table.
I suggest you to try split into Rows in Advanced options. Then you will get a new table which is splited into rows and this may make the calculation easier for you.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tamerj1
Community Champion
Community ChampionHow does your original data look like? Why would you use a comma seperator?