Workfront

Laura-MC · 4/28/23

Can someone assist with what the the reporting filters/text mode (or calculated field if needed) would be to create a report of all active projects in which the planned completion date is greater than 6 months?

Thanks in advance!
Laura

Madalyn_Destafney · 4/28/23

Aha. This may be more helpful as a FILTER in your Projects page instead of a report...
If you have your settings as the start date = the day you're creating the project, you could have the filter be project due on (planned completion date) is less than TODAY+6months

Thoughts?

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

View solution in original post

Madalyn_Destafney · 4/28/23

You're in luck, this is very simple! Include whatever date appropriate, this is example:

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

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

Laura-MC · 4/28/23

Thank you Madalyn.

However, what I am looking for is a filter that can be applied to all of our active projects. So the report will show all active projects in which the planned completion date is 6 months greater than the actual start date of the project.

Madalyn_Destafney · 4/28/23

Aha. This may be more helpful as a FILTER in your Projects page instead of a report...
If you have your settings as the start date = the day you're creating the project, you could have the filter be project due on (planned completion date) is less than TODAY+6months

Thoughts?

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