mahfuja Akhter (LIT) asked in #FormulasDec 13, 2018, 2:55 PMHi, i need to crate a workflow formula to evaluate true. For example, in contact object if field Status or Rating is High and field Group has changes from A to B .1 answerSortSort by DateSort by Most HelpfulSort by DateRajamohan Vakati (Amazon)Dec 13, 2018, 4:01 PMTry this an AND(OR( Text(Status )=="HIGH" , Text(Rating)=="HIGH" ), ISCHANGED( Group__c), TEXT( PRIORVALUE( Group__c) ) = "Active Dialogue" , TEXT(Group__c)=="New") Show MoreReply in Slack
Rajamohan Vakati (Amazon)Dec 13, 2018, 4:01 PMTry this an AND(OR( Text(Status )=="HIGH" , Text(Rating)=="HIGH" ), ISCHANGED( Group__c), TEXT( PRIORVALUE( Group__c) ) = "Active Dialogue" , TEXT(Group__c)=="New") Show More