Forum Discussion

guanel1's avatar
guanel1
Copper Contributor
Mar 30, 2023

Filtering on Calculated Columns not working in SharePoint List

I have a table where i created a calculated column for the Fiscal Year/Quarter = Example: FY2023/Q3. 

I used to be able to filter on this field but now when i filter on it, it provides 0 (ZERO) results. 

 

Any suggestions as to make this work again? Thank you. 

 

If i have to, i can create a flow to pull the calculated column into a text column...if I have to...but id rather not. 

Calculated Column
Filtering
Lists
SharePoint List
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Mar 31, 2023

    guanel1 Peter_Board 

    I noticed lot of customers are facing this issue in their SharePoint sites.

     

    Try to use single line of text as return type for your calculated column like: 

    Note: You may need to delete existing calculated column and create a new one with same formula in some case.

    For detailed information, check my answer at: Filter over Calculated column over the SharePoint List view does not work 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

    • Peter_Board's avatar
      Peter_Board
      Copper Contributor
      Apr 06, 2023
      Hi Ganesh - so after initially thinking it was all fixed with making the column again (as it does work - Filter By right after making the calculated column again), I found that it breaks again if you re-arrange the columns in the List view. So for example, I want "Facility" to be the 2nd column, when I re-create the column its automatically added to the end of the list - if I re-arrange the list View column order, the Filter By command goes back to being broken.
      • Peter_Board's avatar
        Peter_Board
        Copper Contributor
        Apr 14, 2023

        (wrong) Happy to report that the problem seems to have been corrected today. I can now use "Filter By" on calculated columns again. No changes required. Microsoft seem to have corrected the bug that was causing the problem when viewing a List in a List only ASPX page.

        Edit: I spoke to soon... it was working for a bit today, but now I tested again and its stopped working....

        Edit: Ok, I found out that if you flush the Browser Cache, and reload the page - the Filter By works initially - but if you then reload the page, the Filter By stops working

Resources