You need to sign in to do that
Don't have an account?
nelle3223
Dependency Field Rule
Trying to create a dependency for Bid Defense Meeting date field is required based on Bid Defense Required field = yes. For some reason I cannot get it to work. I have so far (Opportunity: Bid Defense Required equals Yes) So field update Bid Defense Meeting Date is required. ANy help would be great. thanks!
NOT(ISPICKVAL( BLANKVALUE(Bid_Defense_Required__c ))
My error is telling me I am missing a ")" but cannot seem to find the missing one.
All Answers
I'll assume that when you say Dependency Field Rule you mean Validation rule. In your current rule criteria, you are just checking that this field equals Yes, now you have to add that the Bid Defense Meeting date is empty so that the error message appears whenever the date is mandatory and empty.
I guess that you are not using the Formula editor, so, you have to add another line and put something like this:
Bid Defense Meeting date equals .
I have not forgotten anything, I'm leaving blank the field where you previously put Yes. This way the validation will be triggered if the date field is empty.
Regards
NOT(ISPICKVAL( BLANKVALUE(Bid_Defense_Required__c ))
My error is telling me I am missing a ")" but cannot seem to find the missing one.
I sometimes find it easier to write the formula out on lines, just like code, so you don't miss any - you can then always flatten them out again
bear in mind Carlos' comments on your formula too though... so even though I have balanced that one, it's probably still not right! :)