I need to create a formula field which returns the date when the status (picklist) field is marked as complete.

I have tried below formula but it is updating today's date for all the ones which were updated long back. Could you suggest what changes need to be made?

    Ispickval(status__c, 'completed'), 
  • What have you tried? Where are you stuck? Edit your question to include that information, otherwise this comes off as a "do my work for me" request.
    – Derek F
    Oct 7, 2022 at 14:16
  • I have added the formula
    – Guest
    Oct 7, 2022 at 14:22
  • I've taken the liberty of adjusting the formula to be syntactically correct, and have retracted my close vote.
    – Derek F
    Oct 7, 2022 at 14:24
  • Have you checked Field History tracking option?
    – Sid
    Oct 7, 2022 at 15:08
  • No, can you tell what to do?
    – Guest
    Oct 7, 2022 at 15:20

1 Answer 1


Formula fields are re-calculated every time that the record is accessed. They're not a one-time calculation, so they are not suited for the problem you're trying to solve here.

Instead, you should use a before-save record-triggered flow with a custom date field to:

  • detect when your record's status is changing to "completed"
  • and then execute an immediate action to set your date field with TODAY()

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.