Solved

"This column type cannot be filtered" - Sharepoint 2010

Posted on 2016-10-18
3
41 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 14

Assisted Solution

by:SneekCo
SneekCo 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 14

Expert Comment

by:SneekCo
ID: 41860294
Thanks
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

706 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

15 Experts available now in Live!

Get 1:1 Help Now