You need to sign in to do that
Don't have an account?
satakshi
Validation Formula for Pickval If changed
I am writing validation formula. In lead source pickval while generating lead if pickval is web or if pickval is changed to web then it should throw error that pickval can not be change into web. I am writing this fromula but its not working.
AND((ISCHANGED( LeadSource )) && ISPICKVAL( LeadSource , 'Web'))
AND((ISCHANGED( LeadSource )) && ISPICKVAL( LeadSource , 'Web'))
Try to check the below validation rule:
As you don't want a lead record to be saved when the LeadSource is "Web" or changed to "Web"
Hope this helps you!
Let me know if you need any help!!
Best Regards,
Deepthi
All Answers
Now i have changed this formula into ISPICKVAL( LeadSource , 'Web'). Now if while creating lead. If pickval is 'Web' then it will throw an error and if its edited and then changed into web then also it will through an error. So that workflow is checking for a leadsource = web will not send any email. Is this right way to do this?
Try to check the below validation rule:
As you don't want a lead record to be saved when the LeadSource is "Web" or changed to "Web"
Hope this helps you!
Let me know if you need any help!!
Best Regards,
Deepthi
The previous Validation rule gives an error for any picklist value change. Kindly try the new updated rule that suffices your exact requirement. Sorry for the confusion.
Best Regards,
Deepthi
Thanks for correction. Its working
Thanks & Regards,
Satakshi