Group by and/or Count by in Smartsheets

Elizabeth Smeller

Hello,

Does Smartsheets have the ability to 'group by' and/or 'count by' similar to the excel pivot table? I have a master list of projects for my entire organization and I would like to be able to do the following:

1. Filter by Status AND
2. Group by PM Name (Assigned To) AND
3. Count of Projects/Clients by PM Name

See example of excel report below - can Smartsheets do something similar or no?

Andrée Starå

Hi @Elizabeth Smeller

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could probably do something similar when the new report design is released.

Would 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!