Skip to main content
Topics#Data ManagementPergunta de Jonathan White
Jonathan White (Salesforce) perguntou em #Data Management
10 de abr. de 2018, 15:43

Formula for Workflow

Hello All I have created the formula below to fire a workflow, it seems to be working for all engineers not just the one specified, where have I gone wrong

 

OR(

 

  AND(

 

    ISCHANGED(Status__c),

 

    TEXT(PRIORVALUE(Status__c)) = "Requested",

 

    TEXT(Status__c) = "Scheduled"),

 

    Engineer__c = "00524000002WIks",

 

  AND(

 

    ISCHANGED(Status__c),

 

    TEXT(PRIORVALUE(Status__c)) = "Requested",

 

    TEXT(Status__c) = "Completed"),

 

    Engineer__c = "00524000002WIks",

 

   AND(

 

    ISCHANGED(Status__c),

 

    TEXT(PRIORVALUE(Status__c)) = "Scheduled",

 

    TEXT(Status__c) = "Completed"),

 

    Engineer__c = "00524000002WIks"

 

)
6 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    10 de abr. de 2018, 15:55
    AND(
    Engineer__c = "00524000002WIks",
    ISCHANGED(Status__c),
    OR(
    AND(
    TEXT(PRIORVALUE(Status__c)) = "Requested",
    TEXT(Status__c) = "Scheduled"),
    AND(
    TEXT(PRIORVALUE(Status__c)) = "Requested",
    TEXT(Status__c) = "Completed"),
    AND(
    TEXT(PRIORVALUE(Status__c)) = "Scheduled",
    TEXT(Status__c) = "Completed")
    )
    )

     

     
Escrever uma resposta...
0/9000