You need to sign in to do that
Don't have an account?
Tarent
hi
I have a custom object with two percent fields. If the "Rate1__c" percentage field has a number entered, but "Rate2__c" is blank and user tries to save, the record should error out and prompt the user to complete the "Rate2__c" field.
I need a VR with this project that is 99% complete and this will save me! lol Thanks!
The API's are:
Rate1__c
Rate2__c
Date Type: Percent
Hi,
Try the below formula as reference:
IF( AND(len( text(Rate1__c ))>0,len(text(Rate2__c ))=0) , true, false)
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
I dont think using 'len' is the native option here.
try this:
AND( NOT(ISBLANK(Rate1__c)) ,ISBLANK(Rate2__c))