Dear fellow members of the "Force",

I have trouble finding a better (more compressed!) way to build the following formula:

A field should check whether one of several countries is chosen ("OR"), then check whether

sex is "male" or "female", then generate a salutation text.

I came up with:

IF(
AND(
ISPICKVAL( Country_picklist__c, "Germany"),
ISPICKVAL (Sex__c, "M")), "Sehr geehrter Herr " + Title + " " + LastName ,
IF(
AND(
ISPICKVAL(Country_picklist__c, "Germany"),
ISPICKVAL (Sex__c, "F")), "Sehr geehrte Frau " + Title + " " + LastName,
null
))

I have no clue so far how to include the "OR" component for countries, which

would save me the increasingly long formula.

Helpful input will be VERY MUCH APPRECIATED !!!

Thanks in advance !

manuelforce

Fellow members of the force !

I'm in dire need of a validation rule that does the following:

only allow values of 0,10,20,40,60,80,100 % in the probabilities field

and release the hounds of hell (error message) if someone enters

something else.

I tried ...

OR(

probability=0, probability=10 .. etc...)

then I tried 

NOT(

OR( ... same thing ... )

Any help much appreciated !!!!

Thanks in adavnce !!!

Hi fellow "Force" users.

I have been trying to locate the solution to this issue for a few days now -

without success.

I would need a formula for a  validation rule to provide the following:

When a user wants to change the sales stage to a higher probability,

a new checkbox appears or is activated (easier to do than the former I think),

which needs to be a required field.

The new sales stage an only be saved if this required box is checked.

Any suggestions on such a formula(s)  (checkbox appears + checkbox is required +

error message when checkbox is not checked) 

would be highly appreciated.

(Making a checkbox required via page layout apparently is not possible)

Thanks a million in advance !

Manuel

Fellow members of the force !

I'm in dire need of a validation rule that does the following:

only allow values of 0,10,20,40,60,80,100 % in the probabilities field

and release the hounds of hell (error message) if someone enters

something else.

I tried ...

OR(

probability=0, probability=10 .. etc...)

then I tried 

NOT(

OR( ... same thing ... )

Any help much appreciated !!!!

Thanks in adavnce !!!

Is it possible to automatically transfer the account owner to an account team member? 

Is it possible to automatically transfer the opportunity owner to a sales team member? 

Is it possible to automatically transfer the sales team members to the account team members? 

If so how best to accomplish?    

Hi fellow "Force" users.

I have been trying to locate the solution to this issue for a few days now -

without success.

I would need a formula for a  validation rule to provide the following:

When a user wants to change the sales stage to a higher probability,

a new checkbox appears or is activated (easier to do than the former I think),

which needs to be a required field.

The new sales stage an only be saved if this required box is checked.

Any suggestions on such a formula(s)  (checkbox appears + checkbox is required +

error message when checkbox is not checked) 

would be highly appreciated.

(Making a checkbox required via page layout apparently is not possible)

Thanks a million in advance !

Manuel