function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Marge MacedaMarge Maceda 

ISPICKVAL and OR

Hi,
The WFR below works everytime the field PV Projet Status is change to either "Given to Foreperson" or "Superintendent" from a blank field OR if the field equals something else aside from Given to Foreperson or Superintendent. However, I also want it to fire everytime it is changed from Given to Foreperson TO Superintendent, or Superintendent TO Given to Foreperson. 

OR ( 
ISPICKVAL(PV_Project_Status__c, 'Given to Foreperson'),
ISPICKVAL(PV_Project_Status__c, 'Superintendent')
)

For it to work, I had to split them into two separate WFR (see below), which is ok but I would like them to be in one WFR.
WFR 1: ISPICKVAL(PV_Project_Status__c, 'Given to Foreperson')
WFR 2: ISPICKVAL(PV_Project_Status__c, 'Superintendent')

Thanks,
Marge
Jim MontgomeryJim Montgomery
Can't you use (text(priorvalue(PV_Project_Status__c,"Given to Foreperson")) && ispickval(PV_Project_Status__c,"Superintendent") || (text(priorvalue(PV_Project_Status__c,"Superintendant")) && ispickval(PV_Project_Status__c,"Given to Foreperson")?