Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
eileen103eileen103 

Need Help Writing an IF Statement that doesn't change the field when the statement is true

Hello:

 

I am trying to create an IF formula where if the formula is true, it changes the field to another date and time, but if it is false, I want it to keep the date and time that is already in the field.

I keep getting an error: Formula cannot use another formula field that directly or indirectly refers to itself when I put its own field name, but I don't know what to put there (see ???? below) so the field does not change at all. 

 

IF( ENT_2__Entitled_Resolve_Time__c >=NOW(),  ENT_2__Entitled_Resolve_Time__c, ????????)

 

or is there another way to do this?

 

Thanks,

Eileen

yagnayagna

Did you try 'Priorvalue' function ?

 

IF( ENT_2__Entitled_Resolve_Time__c >=NOW(),  ENT_2__Entitled_Resolve_Time__c,PRIORVALUE(ENT_2__Entitled_Resolve_Time__c))