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) resu...
Calculated Column
Filtering
Lists
SharePoint List
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

  • Sam1209's avatar
    Sam1209
    Brass Contributor
    Apr 18, 2023

    I have been getting exactly same the issue since the end of February/start of March. Flushing the browser cache resolves it for us until you reload the page too. We are also having issues when grouping by the calculated column (results either duplicate or do not load). I have had a support ticket open for the last month with Microsoft but don't appear to be any closer to resolving this. For us, it is only affecting SharePoint lists (I have tried to replicate on a document library but this works fine).

     

    I also created a branded new SP site, with a new list and a very simple calculated column but am still getting the issue on this one too.

    • LittleAshes's avatar
      LittleAshes
      Copper Contributor
      Apr 25, 2023

      Sam1209 I also am having the same problem with a calculated column. As @Sam1209 said, "Flushing the browser cache resolves it for us until you reload the page."

       

      How can I follow the ticket that you already opened with Microsoft? Can you share the link?

      • Sam1209's avatar
        Sam1209
        Brass Contributor
        Apr 26, 2023
        After several weeks of troubleshooting and escalating with Microsoft we have found that the issue is with Nucelus Sync.

        I have been told by the support engineer on my case that you will need to add the following registry key to each device to disable nucleus sync until Microsoft implement a permanent fix:

        [HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"

        (https://learn.microsoft.com/en-us/SharePoint/lists-sync-policies)

Resources