I would like to create a calculated column that displays the timestamp (mm/dd/yyyy) when a choice was picked from another column. The column in question is named Assessment Status and the choice that needs the timestamp is Ready for Review.

P.S. No infopath or 3rd party apps, just need the calculated formula

  • Yes that is true, I would be creating the timestamp when the status is changed
    – Carl Cham
    Commented Jul 1, 2019 at 3:42

1 Answer 1


Carl, Try this formula.

=IF(Status="Ready to Review",TEXT(NOW(),"dd/mm/yyyy hh:mm"),IF(ISBLANK(Status),"","NULL"))

It works in my online list properly.

Update: It will update the timestamp every time it is edited when the status is ready to review. So if it will be a potential issue, i will recommend you to use a very simple workflow with SharePoint Designer to get this work done. Please let me know if that could be you option. It is out of box and very easy to use/maintain.

  • 1
    Wouldn't that update the field every time the item is saved and 'Status="Ready to Review"'?
    – Morten K
    Commented Jul 1, 2019 at 6:00
  • @MortenK Yes, as you said, it will update the timestamp. Thanks for pointing out this. Per my knowledge, this is kind of the limit of a calculated formula for it does not store values. I guess the best OOB way is still using workflow. Any other ideas?
    – Jerry_MSFT
    Commented Jul 1, 2019 at 6:11
  • 1
    I would do it using a workflow and a second choice field to keep track if the status has changed or not and then simply update a normal date field. I agree calculated fields aren't of much use in this case :)
    – Morten K
    Commented Jul 1, 2019 at 6:38
  • Hi the formula you posted doesn't work (wrong formula). So I played around with it and the forumla that has been accepted was this =IF([Assessment Status]="Ready to Review",TEXT(NOW(),"dd/mm/yyyy hh:mm"),IF(ISBLANK([Assessment Status]),"","NULL")). However, it does not display the date when the status is changed. P.S. The column's name is Assessment Status.
    – Carl Cham
    Commented Jul 2, 2019 at 6:30
  • It only stays as "NULL"
    – Carl Cham
    Commented Jul 2, 2019 at 6:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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