I am trying to add another logical test to my formula. At the moment my formula checks the record type of an opportunity and generates a unique ID number in the formula field.
The formula works fine, and now I want the formula field to be populated when the opportunity stage equals "Invoice".
So basically,I want to add "ISPICKVAL( StageName , "Invoice")" to the below formula.
IF(OPCC__c = "" , IF(OPPS__c = "", IF(OPET__c = "", IF(LMS__c = "", "", LMS__r.CustAuto__c ), OPET__r.CustAuto__c ) , OPPS__r.CustAuto__c) , OPCC__r.CustAuto__c )
I am having trouble adding this criteria to the below formula as I am unsure of the syntax when using "IF" & "AND" Statements in formula's
Any help is appreciated.