I have 3 lookup fields (Approver1,Approver2,Approver3). I need to write validation rule to maintain the Approvers in consecutive order.
Please check these Scenarios:
"Its Like previous value should be Filled"
value Approver1-filled Approver2-not filled Approver3- while filling the value
I need to throw validation error.Why because Approver2 isnot filled. (While filling Approver 3, I need to fill approver 1 and 2(previuos values))
I filled Approver 2 ,Approver1 isnot filled
Approver1-Not filled Approver2- while filling the value
Need to throw validation Error
I have tried below validation rule. It's not working
OR( AND(ISBLANK(Approver_1__c)), AND (NOT(ISBLANK(Approver_1__c)), ISBLANK(Approver_2__c)), AND (NOT(ISBLANK(Approver_1__c)), NOT(ISBLANK(Approver_2__c)), ISBLANK(Approver_3__c)) )
For example in this Situation:
Approver 1 & 2 already filled no need to thow error(while filling appover 3)
Approver1-filled Approver2- filled Approver3-while filling this field Approver4
Approver1-filled Approver2- filled Approver3-filled Approver4
and one more if user filled "Approver 3" and not filled "Approver 4" -then no need to throw error.