Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

Report on when Project Changed Status from Updates Newsfeed

Avatar

Level 10

Has anyone already written a report on how to retrieve the date a project status was changed from the updates newsfeed that you can share?

3 Replies

Avatar

Level 8

Hi!

Not sure if this helps, but our team created a calculated field on a custom form that would tell us the date the project was changed from "Draft" to "Current".

Calculation:

IF(Status='CUR',IF(ISBLANK(Date set to Active),$$NOW,Date set to Active),Date set to Active)

Thanks!

Avatar

Level 10

This is something to ponder to see how I can possibly use this. We want to know the date the project was changed into a particular state. Thank you for sharing, I am soaking up this logic.

Avatar

Level 10

Hi.- have you looked at the new Journal Entry object type that was released in March? I love it!

0694X00000DUoM8QAL.png

For Project status changes you are going to want

Journal Entry >> Field Name equals status {yes it is all lower case}

Journal Entry >> Scope is Blank

If you want task statuses, just change the scope to equals Task. :)