Solved

"This column type cannot be filtered" - Sharepoint 2010

Posted on 2016-10-18
3
93 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 16

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 16

Expert Comment

by:Walter Curtis
ID: 41860294
Thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 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