You need to sign in to do that
Don't have an account?
Validation Rule not stopping on error
Hello, Can someone tell me what I'm missing in the validation rule:
The other values in the picklist are: none, Cold, Warm.
If the field is left blank, the user is still able to bypass but I'm trying to prevent that.
Thanks!
AND( ISPICKVAL( Status, 'Working - Contacted'), ISPICKVAL( Rating, 'Hot') )I'm trying to not let users select save if the Status of Working - Contacted is selected and the picklist Rating field is not selected as Hot and try to save the record, the system should prompt them they will not be able to save this record.
The other values in the picklist are: none, Cold, Warm.
If the field is left blank, the user is still able to bypass but I'm trying to prevent that.
Thanks!
Hope that your day is off to an amazing start. You did a fantastic job, you're only missing one piece of code. Please test the below and report back with your results. Hope this helps and may God bless you abundantly.
Best Regards,
Anthony McDougald
All Answers
Hope that your day is off to an amazing start. You did a fantastic job, you're only missing one piece of code. Please test the below and report back with your results. Hope this helps and may God bless you abundantly.
Best Regards,
Anthony McDougald
We have to use not function in the validation rule for restricting the user to restrict the same.
Use this Rule, this will help you.
Validation Rule:
If you found it useful please appreciate my efforts and mark it as the best answer.
LinkedIn: https://www.linkedin.com/in/soyab-hussain-b380b1194/
Regards
Soyab