Solved

"This column type cannot be filtered" - Sharepoint 2010

Posted on 2016-10-18
3
68 Views
Last Modified: 2016-10-26
I have a SharePoint 2010 library with column name "Name (linked to document with edit document).  When I click on the right black triangle next to this column the drop down has "Ascending", "Descending" and "This column type cannot be filtered". All other columns could be filtered. Is there a  way I can filter the Name column?
0
Comment
Question by:Olga Barannik
  • 2
3 Comments
 
LVL 15

Assisted Solution

by:Walter Curtis
Walter Curtis earned 250 total points
ID: 41850088
You can control this via view settings of the view. From the ribbon you will see a link to "Modify View". From there you can do what you describe.

Hope that helps...
0
 
LVL 5

Accepted Solution

by:
Robin Hall earned 250 total points
ID: 41857018
Olga,

Unfortunately you cannot filter this column.  I wish we could.  You an modify the view like Sneeko mentioned but if you are trying to have a way for staff to filter on the fly, they would need access to modifying the view.

Another OOTB option is to use a Text Filter and connect it to that column by editing the page.  The main downside of this is that the text filter required an exact match.  For example if you were looking for "SharePoint.XLSX", you would need to type that in exactly.  If you just tried "Share", the document would not pull up.  This article talks about Filtering:  SharePoint: Filtering with Web Part Connections

This link talks about using the Text Filter but setting it up via SharePoint Designer which might give you better options:  SharePoint 2010 Search list using OOTB Text filter Web Part

The only other thing I could think of, depending on how important, is to look into Calculated Columns and to see if you can get the Document name into the Calculated Column and try filtering that.

Good Luck!
0
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41860294
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now