Share via

Calculated columns are refinable ?

Anonymous
2015-09-21T03:58:49+00:00

Hello,

I created a column name reference date in a document, library. 

As I wish to classify my document yearly, I created a calculted column, document year as :

=YEAR([Reference Date])

It's a number column, because number provide me the ability to create custom interval with the  refinement webpart.

I linked my column document year with a search schema refinable property : refinableint00

Then in the refinement webpart, I don't see anything, it appears that calculated columns can't be refinable.

Can you please help me with this issue ?

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-10-01T04:21:17+00:00

    Hi Guillaume,

    Sorry for my late response. Currently, it is not feasible to map a calculated column to a refinableint managed property with the out-box feature. This is because refinableint uses Integer to store information, while the value in a calculated column is Text by default. As you may realize, the refinableint managed property will not recognize the Text value in a calculated column.

    To realize this feature, we need some customization formulas or codes. To ensure you get the best support for SharePoint Online customizations, development and coding, I suggest you post a thread in Developer forum (Ask a question) Thanks for your understanding.

    Spike

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-09-22T01:48:23+00:00

    true, it's "working"

    ![](http://fud.community.services.support.microsoft.com/Fud/FileDownloadHandler.ashx?fid=82699e51-8638-48ba-8d43-8b74eca3d1ec)

    but i really that i can use this column with a refinablenumber, because a refinableint or decimal or double enable me to create custom interval.

    and string not...

    i'm still waiting a feedback of microsoft on this issue.

    kind regards,

    guillaume

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-09-21T10:21:54+00:00

    Instead of using refinableint00 can you try using refinablestring00 and see if that works. I remember facing a similar issue in the past with a column datatype as number, not calculated. Maybe the problem lies with refinableint00.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-09-21T06:37:40+00:00

    Hi Eric,

    I confirm the following points 1 and 2.

    Kind regards

    Guillaume

    Was this answer helpful?

    0 comments
  5. Anonymous
    2015-09-21T05:33:27+00:00

    Hi Guillaume,

    Could you confirm the following points?

    1. Could you check if you have added the refiners correctly according to this blog: How to add refiners to your search results page in SharePoint 2013

    2. Have you done a reindexing on the list after you mapped the managed property? You may refer to this article about how to do it: Manually request crawling and re-indexing of a site, a library or a list

    Thanks,

    Eric Yang

    Was this answer helpful?

    0 comments