Getting Error:-"The formula expression is invalid: Syntax error. Extra OR" - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
S GARGS GARG 

Getting Error:-"The formula expression is invalid: Syntax error. Extra OR"

This is formula i am using:-

AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Sales"
)
OR(
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Service"
),
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Market"
), 
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Customer Care"
))

Kundan Kumar JhaKundan Kumar Jha
Hey,

Please expalin your requiremnts.In your formula mismatch parenthesis so you get an error.

Try this,

 AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Sales",
OR(
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Service"
),
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Market"
), 
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Customer Care"
)))
Eric PraudEric Praud
Hi,

Try this instead:
OR(
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Service"
),
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Sales"
),
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Market"
), 
AND(
ISCHANGED([Lead].Status) ,
TEXT(PRIORVALUE([Lead].Status)) = "Customer Care"
))

 
Exams BuzzExams Buzz
This post is really useful and helpful to know more about the things which you have shared. 
www.dumpsexpert.com/76940X-Exam-Dumps.html
Eric PraudEric Praud
@Exams Buzz,

Your comment has been flagged now. DO NOT share exam dumps on this site