Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
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 5

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 5

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