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?

Thanks in advance for any help.

resource testing picture 1.jpg

resource testing picture 2.jpg

resource testing picture 3.jpg

Find more posts tagged with

Sheets

Reports

Comments

Alison

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

contact list 1.jpg

contact list 2.jpg

Alison

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

Ok thank you, I've submitted a ticket.

Meagan Adolphson

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.

=Contacts@row

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…