of_Open_Labor__c <1 && NOT(ISBLANK(Service_Incident_ID__c)) && ISPICKVAL( Status , "Closed") && NOT(ISPICKVAL(Status,"Canceled"))
3 Antworten
Here you go -
AND(
of_Open_Labor__c < 1,
NOT(ISBLANK(Service_Incident_ID__c)),
OR(
ISPICKVAL(Status, "Closed"),
ISPICKVAL(Status, "Canceled")
)
)
Alternatively,
AND(
of_Open_Labor__c < 1,
NOT(ISBLANK(Service_Incident_ID__c)),
CASE(
Status,
"Closed", 1,
"Canceled", 1,
0
) == 1
)