Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Column to track status and date status changes

Avatar

Level 5

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?

1 Accepted Solution

Avatar

Correct answer by
Level 6

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. 

View solution in original post

3 Replies

Avatar

Correct answer by
Level 6

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. 

Avatar

Level 5

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.

Avatar

Level 5

I'm just gonna repost this as a new question. Thanks for the quick response. Here is the new post Mark Status Timestamp In Field