function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vijay Patil 1Vijay Patil 1 

Handle Apostrophe in picklist value formula?

Can anybody knows how should I handle single quote (apestrope) in below code?
OR(ISPICKVAL(Status,'In Progress- Engineering'),ISPICKVAL(Status,'In Progress- PLM's'))
Anil MalneniAnil Malneni
Hi Vijay,

check the below code..

OR(ISPICKVAL(Status,"In Progress- Engineering"),ISPICKVAL(Status,"In Progress- PLM's"))

Thank you,
Anil
Vijay Patil 1Vijay Patil 1
Thanks Anil for your quick response. I also tried this way but it not working as excepected. Do you have any alternative?
Anil MalneniAnil Malneni
Its working for me vijay..however you can try the below one...

OR(TEXT(Status)= "In Progress- Engineering",TEXT(Status)= "In Progress- PLM's")

Thank you,
Anil
Vijay Patil 1Vijay Patil 1
I have tried above and received below error :
Incorrect parameter type for function 'ISPICKVAL()'. Expected Picklist, received Text

The above formula is in my workflow formula criteria.