Report Sorting Assigned To Column
Hi,
I had posted another discussion about an issue, but I think I have another issue that might fix my previous issue if I can resolve this current issue. I was having trouble with manipulating tasks and having a view of all resources to be able to manipulate tasks. Here is that post:https://community.smartsheet.com/discussion/resource-allocation-and-manipulation
My current issue is:
I cannot sort a report based on the 'Assigned To' column. I can sort the report based on other columns, but not the 'Assigned To'. In my screenshots below, I show not being able to sort based on 'Assigned To' (pic 1), then I show that I CAN sort based on 'Primary' (pic 2), and then I show that I CAN sort based on 'Start' (pic 3).
Why can I not sort on the 'Assigned To' column?
提前感谢y help.
Connor Hartford
Comments
-
Alison Employee
Hi Connor,
Is this "Assigned to" column a dropdown list? It looks like it may be in the source sheet. If so, a Report will sort based on the order of your dropdown list, so I'd recommend making sure that it is a Contact List column by going to the source sheet > right-click on the column header > "Edit Column Properties" and ensure that this is a Contact List column.
If it is a Contact List column, let me know!
Alison
-
Connor Hartford ✭✭✭✭✭
Hi Alison,
Yes, both of the columns in either sheet are a 'Contact List' type. I have other groups of sheet where I am using real names, usernames, emails, and I am getting the same issue. I just made these testing screenshots for this post.
Connor
Connor Hartford
-
Alison Employee
Hm, strange.
I'd say that you'd likely want to reach out to our Support team (smartsheet.com/gethelp) to see if they can help you out with this.
Sorry I wasn't able to get you a solution right away!
-
Connor Hartford ✭✭✭✭✭
-
I also am having an issue. It is very embarrassing. I assured my boss that I was able to create a system for reporting with everyones info together and I can't. Seems like a simple thing to be able to sort assigned to's. Please fix this soon!!
-
Andrée Starå ✭✭✭✭✭✭
Hi Meagan,
As a possible workaround, you could add a helper column that shows the values in the Contact column with something like the below example and then sort that column instead.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Andrée Starå ✭✭✭✭✭✭
Hi Meagan,
How did it go? Did it work with my suggested workaround?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.