Salesforce Developer Community

Hello,

Is there any way to assign tasks to multiple users besides creating other custom field?

TIA!!!

I am trying to build a custom field to be used in mail merge and am having problems with Salutation.

If Salutation field is populated I would like a space following the Salutation. If Salutation is empty then no space.

So why does this work:

IF(ISPICKVAL( Salutation , ""), "", "Mr,Mrs etc" & " " )
& FirstName & " "
&LastName

Mr,Mrs etc George BushTony Blair

But this:

IF(ISPICKVAL( Salutation , ""), "", Salutation & " " )
& FirstName & " "
&LastName

results in: Error: Field Salutation is a picklist field. Use it with an ISPICKVAL() or CASE() function instead.