function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Michelle Arndt 18Michelle Arndt 18 

Formula Help please

I need a formula for if the opportunity stage is not Closed Lost, Closed Won, or Closed - Declined to Quote and the Date Due opp is greater than 5 days. Pleae and thank you :)
Best Answer chosen by Michelle Arndt 18
Michelle Arndt 18Michelle Arndt 18
AND( 
CASE( 
StageName, 
"Closed Lost", 1, 
"Closed Won", 1, 
"Closed - Declined to quote", 1, 
0 
) = 0, 
 CloseDate < (TODAY()-15) 
)

All Answers

Raj VakatiRaj Vakati
Hi Michelle ,

Hers is the formula 

IF( 
OR(Text(StageName)=='Closed Los' ,
Text(StageName)=='Closed Won'  ,
Text(StageName)=='Declined to Quote'  ,

), 
 
 Date_Due__c> TODAY()+5
  ,
False )

 
Michelle Arndt 18Michelle Arndt 18
AND( 
CASE( 
StageName, 
"Closed Lost", 1, 
"Closed Won", 1, 
"Closed - Declined to quote", 1, 
0 
) = 0, 
 CloseDate < (TODAY()-15) 
)
This was selected as the best answer