function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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.