I have a list box with something around 2500 fields on that particular list box i have one value "LEGAL & CUSTOMER COMMUNICATION" and i want to display only that value as LEGAL & CC.
Thanks in advance
Try like this:
if(filedname='LEGAL & CUSTOMER COMMUNICATION','LEGAL & CC',filedname)
Please see the attachment for demo.
Thankyou Avinash and Amit
I am using
= if([Function Name] = 'LEGAL / CORPORATE AFFAIRES', 'LEGAL & CA', Upper([Function Name]))
This in list box expression, but my always selected one value is not working and function name mapping also disabled..... any idea?
Use this expression in the script, this will solve the issue
Thanks a lot Aninash
Retrieving data ...