Our team is trying to figure out how to finish out this formula, but keep running into the 3rd "If" validation rule. Can someone help us finish this to work?
2 个回答
IF(ISPICKVAL(Type,"New Business"),
IF( (CloseDate <> Today()-365),
IF(Contract_Term_of_Yrs__c <12,Annualized_Amount__c,New_Business_Amount__c),
0),
0)
I think this is right.
