You need to sign in to do that
Don't have an account?
Aruna Dhavaleswarapu 4
Validation rule to enforce users to enter all values in a section even if one value is entered in that section
I have 3 fields in a section.
I have to write a validation rule when a value is entered in one field in a section enforce the user to key in values for all other fields in that section.
AND(
OR(
AND(
(x__c> 0),
OR(
ISBLANK(y__c),
ISBLANK(z__c)
)
),
AND((y__c > 0),
OR(
ISBLANK(x__c ),
ISBLANK(z__c)
)
),
AND((z__c > 0),
OR(
ISBLANK(x__c ),
ISBLANK(y__c )
)
)
),
(RecordType.Name = "abc")
)
Here is my VR.... Any help would be appreciated.. thanks,
I have to write a validation rule when a value is entered in one field in a section enforce the user to key in values for all other fields in that section.
AND(
OR(
AND(
(x__c> 0),
OR(
ISBLANK(y__c),
ISBLANK(z__c)
)
),
AND((y__c > 0),
OR(
ISBLANK(x__c ),
ISBLANK(z__c)
)
),
AND((z__c > 0),
OR(
ISBLANK(x__c ),
ISBLANK(y__c )
)
)
),
(RecordType.Name = "abc")
)
Here is my VR.... Any help would be appreciated.. thanks,
Mark this post green if it helps :-).
Cheers, Dev
All Answers
Mark this post green if it helps :-).
Cheers, Dev
Your solution resolved the issue.