Grouping in reports does not show headers of the drop-down list

Vishal Tandel

Hi

I am a new user trying to test and see how much I can pull off from this amazing sheet. Well, I am trying to create a report with all the tasks for any given stakeholder. I am grouping the report based on the primary field that has values within a particular header as in the ss below:

And, if you look at the report, it does not show if the line item belows to Campaign 1 or any other dropdown header.

Is there any workaround or straightforward fix to this?
All I am trying to achieve is that Stephen can see all his tasks with the Campaign headers.

AKnight

Hi Vishal!

Your dropdown header in your report will be based around what column you used to group your report. In this case you grouped it by the primary column so it is showing you every instance "Creative 1" appears rather than what the original dropdown header is.

If your goal of this report is to easily see who owns each task, I suggest grouping by owner instead of by the primary column.

If you are worried about loosing the hierarchy you have in your sheet in your report, I suggest making a new column in your sheet called "Hierarchy", use this formula: =JOIN(ANCESTORS(Primary Column@row), “-”), hide that column in your sheet, then add the column to your report. This will allow you to see where tasks in your sheet come from.