Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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. :)