Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Report for active projects where planned completion date is greater than 6 months

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

Madalyn_Destafney_0-1682709628928.png

Thoughts?

 

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

View solution in original post

3 Replies

Avatar

Community Advisor

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

Madalyn_Destafney_0-1682705703789.png

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

 

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

Avatar

Level 2

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. 

Avatar

Correct answer by
Community Advisor

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

Madalyn_Destafney_0-1682709628928.png

Thoughts?

 

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