Display/Filter on Last Updated Date for Custom Field

Forum|Forum|1 year ago
April 2, 2024
1 reply
912 views

The goal is to create a Project report, only displaying projects that had their Weekly Update field updated within the last week / 7 days.

Weekly Update is a paragraph textbox custom field - it's updates are being tracked within the Updates system feed/activity. Team members update this the weekly update custom field when there are major updates to the project. Then we want to use a report to view only projects where that field was recently updated.

How am I able to capture and filter on the Last Updated date value for a custom field on a project report? Can I create a calculated field that can capture and display this date?

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Madalyn_Destafney

Community Advisor

Hi there, have you played with a journal entry report for this yet? Could have filters like these to look for when the field was updated, the field you're isolating, etc. Then you can even have columns for 'old text value' and 'new text value' if you want to see the old vs. new text, as well as who made the edit, when, etc.

If this helped you, please mark correct to help others : )

Denver-LemontAuthor

Level 2

I explored this option, but a Journal Entry report doesn't meet requirements / runs into some issues:

1. If a user updates the Weekly Update field twice in a week, then the Journal Entry report now displays two rows for the same project.

2. This report needs to display other project level custom fields. I'm able to display those other project level fields on the Journal Entry report. However, if someone first edits the Weekly Update field + saves, then later updates a different project field (e.g. description) - then edits to other fields will not appear in the Journal Entry report as I'm only wanting to filter based on one specific field (Weekly Update).

3. Some users want to use this report to also edit the project field values within the report. This isn't a hard requirement, but nice to have since they are able to edit their projects within other reports.

Madalyn_Destafney

Community Advisor

Hi there,

On #1, I'm not sure that's a bad thing? You want the visibility anytime this field is updated it sounds like.

#2, you can bring in other columns to show other fields or add filter sets in your report to capture changes to other fields too - your initial question was wanting to isolate this one field, not others.

#3, correct, you cannot edit a journal-entry report in-line. That isn't the intention of the report, it's showing actions that have happened.

If this helped you, please mark correct to help others : )

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded