filter in sharepoint list doesn't work

Question

hi microsoft team's

i have a problem with my sharepoint list when i want filter on the column with the formula (such as IF AND) , it doesn't work like the others column which dont have formula inside. the notification that appear like attached.

i hope there is a solution for my problem

thankyou

Answer 1

Dear Paula Wulandari Soetjipto,

Thanks for writing back to us and sharing the requested information.

As per the updates, I have checked the behavior on the multiple lists with calculated column where I noticed the inconsistent behavior, where some list gave correct filter results, and some gave the same error as you are encountering.

So, when I have checked the related Microsoft KB’s, I noticed that calculated column is the unsupported column for indexing and Filtering:

Reference: https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4 

So, I believe that’s the reason we are encountering the unexpected behavior when applying the filter on the Calculated Column. In addition, I would like to suggest you to add you valuable feedback in the SharePoint Feedback Forum: https://feedbackportal.microsoft.com/feedback/forum/06735c62-321c-ec11-b6e7-0022481f8472 

Thanks for your patience and understanding.

Have a good day!!

Best Regards,

Sophia

Answer 2

Hi Sophia,

so sorry for late reply

thankyou for response my question and have a great day :)

this is the screenshot of the notification :

and the formulas are :

hope it'll find a way :)

thanks before

Answer 3

Dear Paula Wulandari Soetjipto,

Good day!!

As per the description shared, I understand you are trying to filter the SharePoint Online calculated column and encountering behavior which isn't normal. However to better understand your situation, can you please share the screenshot of the behavior? (The attached screenshot is not present in the post)

Moreover, if possible please share the formula using the Calculated column.

Thanks for your understanding.

Best Regards,

Sophia