Tracked Custom Field Updates Reporting

Question

I am currently tracking a custom field to show up in Updates a timestamp of who updated it. Is there a way to pull that "Updates" info into a report, even if I have to export the report and manually extract it from more info? We are moving that custom field from the project level to a document level, and I need to compare timestamps of that vs when documents were added to see which docs were added before the project level custom field was updated.

Thank you!

Madalyn_Destafney · Accepted Answer

Hi, so you're looking to see what was filled into that specific field/when/etc, correct? If so, I recommend a journal entry report...more on journal entry reports here.

RandyRoberts · Answer

Or you could use a calculated field like I did for this:

This field lists all the statuses of a project and the date they changed.

LEFT(IF(LEFT({DE:Project Status History_},LEN(IF(ISBLANK({status}),"-",{status})))={status},{DE:Project Status History_},CONCAT(IF(ISBLANK({status}),"-",{status})," (",$$NOW,") | ",{DE:Project Status History_})),2000)

Sign up

Login with SSO

Login to the community

Login with SSO