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?
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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. :)