I only want the status to be set for leads with a status other than "New".
AND(NOT(ISPICKVAL(Status, "New")),
IF(AND(Age_of_Lead_Hours__c >=0,Age_of_Lead_Hours__c <7),"GREEN",
IF(AND(Age_of_Lead_Hours__c >6,Age_of_Lead_Hours__c <13),"YELLOW",
IF(AND(Age_of_Lead_Hours__c >12,Age_of_Lead_Hours__c <25),"ORANGE",
IF(Age_of_Lead_Hours__c >24,"RED","ERROR")))))
답변 3개
IF(AND(NOT(ISPICKVAL(Status, "New")),Age_of_Lead_Hours__c >=0,Age_of_Lead_Hours__c <7),"GREEN",
IF(AND(NOT(ISPICKVAL(Status, "New")),Age_of_Lead_Hours__c >6,Age_of_Lead_Hours__c <13),"YELLOW",
IF(AND(NOT(ISPICKVAL(Status, "New")),Age_of_Lead_Hours__c >12,Age_of_Lead_Hours__c <25),"ORANGE",
IF(AND(NOT(ISPICKVAL(Status, "New")),Age_of_Lead_Hours__c >24),"RED","ERROR"))))
