Report on Tasks by Assigned User across multiple Sheets

Rene_BerlinChemie

Dear all,

I´m familiar with the usage of the 'current user' filter in reports on multiple sheet. This works good as long you want to provide individual lists to the user opening/using a report.

I do look for an option to build a report on tasks categorized by the user assigned. The field 'Assigned To' is not available in the selection for this feature.

Does anybody have an idea?

Greetings

René

Andrée Starå

Hi @Rene_BerlinChemie

I hope you're well and safe!

Not sure I follow. Can you elaborate?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Rene_BerlinChemie

Hi Andrée,

I would like to create a report across multiple sheets, which lists all tasks are pending/in progress by 'Assigned To'. Unfortunately we sometimes work with multiple names as 'Assigned To'.

When I use the 'Group' feature it will no allow me to select the field 'Assigned To'. Maybe this is caused by the usages of 'multiple contacts per cell'!?

Many thanks for your feedback

Paul Newcome

You cannot group a report by a multi-select column.

Feel free to browse the Product Ideas tab at the top of this page. If the someone has already submitted this idea, feel free to add your vote. If no one has submitted it yet, you can submit it yourself.

Either way, please provide a link to the idea here so that others searching for the same thing can easily add their votes.

Andrée Starå

@Rene_BerlinChemie

Happy to help!

Unfortunately, it's impossible to group it when it's a multi-select column.

• As a possible workaround, you could split out all options into separate columns and then use them for the Current User filter.

Make sense?

Also, Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!