You need to sign in to do that
Don't have an account?
Help on updated validation rule
I have this validation rule below for when a user selects Under Contract from the Report Status Category picklist, user must make a selection from the "Contract Includes WC" picklist before saving the record, if not, user will receive an error to make a selection.
AND( ISPICKVAL(Report_Status_Category__c, "Under contract" ), ISPICKVAL(Contract_Includes_WC__c, ""))
However, I need an updated validation rule that will do the following using some of what was used previously.
The "Contract Includes WC" picklist is only available when the following criteria are met:
- "Report Status Category" picklist = "Under contract"
AND
- "WC Target" (checbox), is slected True
When these two criterias are met, user must make a selection from the "Contract Includes WC" picklist.
Any ideas?
Thanks!
API Names:
Picklist: Report Status Category = Report_Status_Category__c
Picklist: Contract Includes WC = Contract_Includes_WC__c
Checkbox: WC Target = WC_Target__c
It's your lucky day, I'm having a 2-for-1 Sale...
and this one closes the loophole
All Answers
Are you trying to amend the existing rule or create a new one from scratch?
A new one is fine with me if that is the case Stevemo....
It's your lucky day, I'm having a 2-for-1 Sale...
and this one closes the loophole
Once again, you have pulled through! Thanks Stevemo!!!
Stevemo, maybe you can help me on modifying this one you did for me a while back.
I need to add another string to this validation rule.
Need this modified to when another checkbox is selected, the rule must be required when one or the other checkbox is selected. So, if either "ACL_MPI__c" or "ACL_DDD__c", are checked, "Contract_Includes_WC__c", must be required.
Let me know sir!
you mean like this?
yeah that's it!!!! thanks!!!!!
No problem, you owe me a beer (and I drink these!) -> http://beeradvocate.com/beer/profile/863/7971