Not able to Group a Report Using Fields in the Report

Maxine Roberts

I have created a report and it's not letting me group the rows by PQE even though it's a field in the report

James Keuning

What do you mean by "it's not letting you?" The column name is not available in the Group selector? Did you scroll all the way down, sometimes fields get removed from the source, and then re-added.

Maxine Roberts

@James Keuning it's not available for selection the list I've been all of the way through the whole list and PQE is not showing as an option

James Keuning

What is the field type? Single entry?

Andrée Starå

Hi @Maxine Roberts

I hope you're well and safe!

Are you using the column for sorting? If yes, you can use the same column for both.

Did that work/help?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Maxine Roberts

@James Keuning It's a single contact type as I have other reports grouped using a field of this nature

@Andrée Starå I am well thanks hope you are also. No I'm not using the column to sort I just want it to group these entries together

Debbie Sawyer

Seems very odd.

You can definitely group by a contact list datatype.

PQE is definitely in the report

Does it have any data in the column?

I don't think it is your Primary Column, but the Primary column appears in the grouping list as Primary Column and not the normal column heading that you have given it? Could it be that you have renamed the column in the report and are looking for the renamed name and not the underlying name?

I'd be more than happy to set up a zoom so you can show me the issue and we can see if we can sort it out?

Kind regards

Debbie

Ke6n

I ran into this as well because the column was a multi-select drop down. I guess I hoped it would group each unique combination of selected values as a group. But I could see that getting unwieldy if there were a lot of options or a lot of values selected.

Robin Herrick

I've found a similar issue where Smartsheet picks a "primary column" and calls it that in the group dropdown rather than the parent column name. Kinda confusing.