+ Start a Discussion
Pankaj KPankaj K 

Help in setting Formula for Workflow

Hi,

 

Thanks in advance..

I getting error when i am checking syntax in Formula "Error: Function PRIORVALUE may not be used in this type of formula"

 

My Formula is 

 

AND
(
	AND
	( OR
		( AND
			( 	 ISPICKVAL(Email_Verification_Status__c, "Verification Failed"),
				(ISPICKVAL( PRIORVALUE(Email_Verification_Status__c) , "Primary Email Verification"))
			), 
		  AND	
			(
				ISPICKVAL(Email_Verification_Status__c, "Verification Failed"),
				(ISPICKVAL( PRIORVALUE(Email_Verification_Status__c) , "Secondary Email Verification"))
			)
		),
		Active__c  = "True"
	),
	RecordType = "PRG Employee"
)

 HIstory Tracking is enabled for the Email_Verification_Status__c.

 

Anyone please can tell how to resolve it or correct the formula.

 

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

When is your WFR set to trigger?

 

PRIORVALUE (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the trigger type is set to Every time a record is created or edited)

All Answers

SteveMo__cSteveMo__c

When is your WFR set to trigger?

 

PRIORVALUE (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the trigger type is set to Every time a record is created or edited)

This was selected as the best answer
Pankaj KPankaj K

Hi Stevemo,

 

I have not set Evaluate rule to Every time a record is created or edited. 

 

thanks..