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

Report on when Project Changed Status from Updates Newsfeed

  • May 10, 2021
  • 3 replies
  • 705 views

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

KierstenKollins
Community Advisor
Community Advisor
May 12, 2021

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!

BenettaPeAuthor
Level 9
May 12, 2021

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.

imgrund
Adobe Employee
Adobe Employee
May 13, 2021

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