I am trying to make a formula which will return the date when the checkbox was clicked. This is what I got now and it's not working since it gives the value for all fields as same date.

if(Call_Attempts__c = True , NOW(), NULL ) 

I know that the code NOW() gives all values for current date for all fields and I need a return date for last modified specific field.



  • All that formula is doing is displaying the current date when Call_Attempts__c is true. What you are trying to do is not possible with a formula. You would need to create a new date field (e.g. Call_Attempts_Date__c ) and set it in a trigger when Call_Attempts__c is checked. – BarCotter Apr 8 '15 at 11:00

Instead of a formula, create a new Date or Datetime field, and update it to NOW() via a Workflow Field Update or via a trigger, whenever you detect that the Checkbox value has been changed from False to True.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.