Report on when Project Changed Status from Updates Newsfeed | Community
Skip to main content
Level 9
May 10, 2021 4:24 PM UTC
Question

Report on when Project Changed Status from Updates Newsfeed

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

imgrund
Employee
May 13, 2021 2:35 PM UTC

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

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

Translate
BenettaPeAuthor
Level 9
May 12, 2021 12:52 PM UTC

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.

Translate
KierstenKollins
New Participant
May 12, 2021 4:32 AM UTC

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!

Translate