Using the "Like" operator in Custom Formula
HI there,
Can someone please explain the way to use the "LIKE" operator in an IF statement to compare strings? I have tried the following but am not getting the results I'm after.
if( "CurrentStatus" like 'Rejected*','Unsuccessful','Pipeline')
Thanks
Matt