Forum Discussion

rdgbasilio's avatar
rdgbasilio
New Member
4 years ago
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 ...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.