I have a SharePoint list. It has a column called 'Closed Date', it keeps only date value of date only type and optional. Now I have created one more calculated column called Closing Year. The formula for the closing year field is as below:

=IF(ISBLANK([Closed Date]),"",TEXT([Closed Date],"YYYY"))

Now the calculated field is able to show Year value for respective records if closed date is not blank otherwise empty value.

On the list view page, If I try to explicitly filter with any year value as displayed under the filter popup options, it does not return any result. It displays no result.

Kindly help me with this as I am stuck here.

Thanks in advance!

1 Answer 1


Try use settings like below for your calculated column:

enter image description here

List View without filter:

enter image description here

List View with filter:

enter image description here

  • 1
    Thanks for replying over this. The Issue I observed like before it was working with the filtration. Now it was not broken. As per your suggestion, I deleted and recreated the field and now it is working. Thanks Mar 30, 2023 at 10:52
  • Great, glad it worked for you. Mar 30, 2023 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.