Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kenny ellekenny elle 

validation rule on formula field which is referrincing the other field picklisy field on the oppty object

Hi
i have a formula field regularitives it is a formula field which is referrencing the field on oppty object and it is a picklist field now i have to write a validation rule such that when regularitive = canada then stage and status is new other wise error should come.
ShirishaShirisha (Salesforce Developers) 
Hi Kenny,

Greetings!

You can try the below formula and make changes accordingly.
  
AND(ISPICKVAL(regularitive, "Canada") ,Stage !="New" , Status !="New")

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri
kamala swarnalathakamala swarnalatha
Hi Kenny,

You can try the below formula 
AND(
ISPICKVAL(regularitive, "Canada"),
NOT(ISPICKVAL(Stage,"New")),
NOT(ISPICKVAL( Status,"New"))
)
Hope this helps!

Please let me know if you have further questions.

Thanks,
K.Kamala
Sweet Potato Tec.