Grouped Reports with multi-select dropdowns
Apparently there is no way to group reports by columns that are multi-select dropdowns. Is there any workaround for this?
Answers
-
You're correct, currently Grouping in Reports is available for single-select dropdown lists. Please let our Product Team know about your feedback and what you'd like to see through this form, here.
Can you explain your process a little more? It would be helpful to see screen captures of your source sheet (but please block out any sensitive data). We may be able to figure out an indicator (likely using a formula in a helper column in the sheet) based on the multi-select options that you can then use to Group.
Cheers!
Genevieve
-
I am looking to group a customer column as well. I changed the column to a single drop down column however, now the customer names are not populating in the report. Will it take effect moving forward? I am trying to summarize hours spent on each customer, so this would be really nice to be able to summarize and group by customer.
-
I hope you're well and safe!
You'd need to add the column (new) again and remove the old one. The column type change makes it a new column.
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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives