Apr 15 2020 03:44 AM
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 Pedreira