You need to sign in to do that
Don't have an account?
yves
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
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".
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