Sharepoint 2016 Server - Format for refiners with calculted columns
Hi, I need to use refiners in a results page for a Calculated Column. I have a problem with the values format. My list is the next one: Where poc2FechaDerogacion is a Date field and poc2EstadoVigencia is a Calculated Column: =SI(HOY()>poc2FechaDerogacion;"No Vigente";"Vigente") My problem is the format marked in yellow: How can I avoid the "string;#" text in my results? I was waiting for 2 values, "No Vigente" and "Vigente" (the same values shown in my list) Regards, María PedreiraRefiners of top level sites
HI, In a webpart, I need to refine by the name of the top sites in a site collection. I've found the Managed Properties SPSIteURL and ParentLink... SPSIteURL: https://mySiteCollection ParentLink: https://mySiteCollection/site1/site1b/List/Documents/Forms/AllItems.aspx https://mySiteCollection/site2/site2b/site2c/List/Documents/Forms/AllItems.aspx or SitePath... Neither of these properties are good, I need to detect site1, site2, ...siteN Any idea about how to get this information in a managed property to use it like an Avaliable Refiner? Thanks
