Alphabetize Filter Options

In one of my sheets, I can create a filter for the field "Project Manager"

In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, see a scrollable list of project managers - out of order - How can I alphabetize this list?

2019-06-18 10_10_32-Manufacturing Backlog - Smartsheet.com_.png

Find more posts tagged with

Sheets

Support

Solution Center

Comments

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Terrapin69

Interesting - Because most fo the sheet appears to be alphabetized already but gets wonky in spots.

Perhaps knowing the source of the filter options is a good start?

Andrée Starå

Is it a contact column?

Terrapin69

It is a column that lists names of employees. Not sure what you mean by "contact column"

Andrée Starå

There are different column types and one of those is a contact column. Can you double check?

Terrapin69

The current type is "contact list"

Andrée Starå

I tested, and in my case, it shows them in the same order as the Contact Column List values. To have them in alphabetic order you would have to add them in that order to the value list.

Hope that helps!

Terrapin69

sorry for the dumb question, but can you direct me to where the "list column" or "source" is?

Andrée Starå

There are no dumb questions!

It's on the right side of the contact list column settings.

More info: https://help.smartsheet.com/articles/504619-column-types#contactlist

Hope that helps!

Sign in to join the conversation!

Quick Links

Trending discussions

Set Up Links for Board View
In my grid view, I added a column that takes a hyperlink but when I mosey on over to Board View, only some of the columns appear as attributes displayed on the card. Can I make the hyperlink appear here?
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…
Automatic Unalignment of Dashboard Widgets
Is anyone experiencing their dashboard widgets automatically being unaligned or they have moved a bit from your last save? I am the type where I like things clean and aligned. Some may say it's OCD. In Dashboard, this can mean the edges of my widget line up, each section is centered or same purposed widgets are the same…