Share via

SharePoint List-Filter Issue

Anonymous
2024-03-04T21:04:02+00:00

Is there a way to just have your individual choice options come up when you select "Filter By" instead of all the combinations that were selected? For example, we have all the counties in the state in one of our columns, and I just want the individual counties to show up and people can select more than one if they want to filter for more. All the combinations are making it really hard to read and making the filter lists too long and overwhelming to look at.

What I want:

Anoka

Dakota

Hennepin

Ramsey

Stearns

What I keep seeing:

Anoka

Anoka, Hennepin

Anoka, Hennepin, Ramsey

Anoka, Hennepin, Ramsey, Stearns

Dakota

Dakota, Hennepin, Ramsey

Dakota, Ramsey, Stearns

Hennepin

Hennepin, Ramsey, Stearns

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-05T04:26:14+00:00

    Dear JM,

    I'm afraid that there is no built-in option automatically filtering the choices of the filter pane.

    If you want to only show the county name before the comma, you can add a calculated column County Calculated as follows to only show the county name like the following.

    Calculate data in lists or libraries - Microsoft Support

    Formula: =IF(ISNUMBER(SEARCH(",",County)),LEFT(County,FIND(",",County)-1),County)

    Thank you for your time and effort.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments