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, 2015 at 11:00

1 Answer 1


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.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .