Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
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 : )