Skip to main content
Need to update formula to trigger a validation rule on either picklist value of Closed or Canceled.

 

of_Open_Labor__c <1  &&  NOT(ISBLANK(Service_Incident_ID__c)) &&  ISPICKVAL( Status , "Closed") && NOT(ISPICKVAL(Status,"Canceled"))
3 Antworten
  1. 20. Sept. 2017, 16:58

    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

    )

0/9000