Column to track status and date status changes | Community
Skip to main content
Lawson02
Level 6
October 16, 2024
Solved

Column to track status and date status changes

  • October 16, 2024
  • 1 reply
  • 939 views

I know that I can create a field to track status timestamps but can I create a report column that does that for me instead?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

You cannot. You need to create one-time-write calculated fields (look for Doug's explanation here) for whenever the status changes to one you want to track. Then you can display that field as a column in a report. 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
October 16, 2024

You cannot. You need to create one-time-write calculated fields (look for Doug's explanation here) for whenever the status changes to one you want to track. Then you can display that field as a column in a report. 

Lawson02
Lawson02Author
Level 6
October 16, 2024

How would I create a field that only stamps when the status is changed. I tried using dougs formula but the field always updates when any other field is modified. For example I want to track On Hold, status is changed to On Hold, time is marked, but it is updated when still in status and other fields are updated.