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
yvesyves 

Need help with a if statement

Here's what i need to figure out
 
i already created my formula text field that say's
 
IF(date_field__c >= TODAY(), "Entitled", "Not Entitled")
 
But i need to add something that would take into account
 
and If past value = entitled and ''query=xyz'' then .....
 
how can i have a past value into an ''IF''  formula
 
thanks
Erica KuhlErica Kuhl
You can nest in OR in the formula to look at another field.

IF(OR(date_field__c > = TODAY(),query=xyz)...

You mention a "past value"...where do you keep that "past value".  This may take it beyond using a "formula".
yvesyves

well the formula text field takes into account a date field t

compares it with today's date and give entitled or not

but when my previous result on my formula field was entitled and i have between 0 and 5 days left  

i need to change from entitled to almost over

thanks