Syntax for picklist item with apostrophe
I am writing a CASE statement in a report formula and am having issues with it taking the apostrophe that is in the picklist field name. I get a syntax error when I leave the apostrophe in it, but when I take it out, the formula does not work correctly because the picklist name isn't exact. I also tried replacing the apostrophe with the ASCII character which validated in the formula, but did not work in the output. The formula works fine if I test it using a picklist name with no apostrophe in it. Does anyone have any advice?