+ 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.