+ Start a Discussion
TarentTarent 

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

Navatar_DbSupNavatar_DbSup

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. 

Noam.dganiNoam.dgani

I dont think using 'len' is the native option here.

 

try this:

AND( NOT(ISBLANK(Rate1__c)) ,ISBLANK(Rate2__c))