Hello! I created a report with several columns, however, it does not allow me to group by using the assigned to column (setup as a contact list) . Does anyone know why this is happening?
I'm not 100% certain on this, but I am guessing your contact list is multi-select, I believe you cannot currently group by multi-select dropdown/contact lists.
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Dan - Thank you as that seems to be the issue! I created a test report and removing the multi-select allowed me to group by via the assigned to field.
@Kenya Asbill My pleasure, and good to know!
I turned multi select off and now I get a report with "multi select" the name on every group in my report. However, the Assigned to is not multi select and there is only one name in the assigned to.
Hi @Lyz Kelk
I hope you're well and safe!
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some more screenshots of the grouping/sorting settings? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Be safe and have a fantastic week!
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
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Did more digging and found that ALL sheets the report is looking through must have multi checkbox off.
Glad you got it working!
I've had similar results as described above when trying to Group using the Assigned To field in a report. However, I also discovered that you can create a sheet with multiple Assign To option turned OFF. Then create a report using that sheet and establish a group on the Assign To field. Then go back to the sheet and turn ON the option for multiple select (in the column properties) and add multiple contacts into the rows as needed. The report will continue to work but will auto adjust to allow for the multiple contacts selection. It will give you the pop-up warning, but the report keeps working.
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.