Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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 4

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. 🙂