Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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) 
Steve :-/Steve :-/

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

Steve :-/Steve :-/

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..