+ Start a Discussion

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



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?





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))