2

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.

Thanks,

Darko

Improve this question
1
  • 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

Reset to default
5

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
0

You must log in to answer this question.

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