How to generate a report for all active projects for the next 4 weeks ahead
Hi everyone, I generate a report quite frequently for all active project for the next 4 weeks ahead. I currently just go through all projects and check on a column I created and them pull the data in a report, but my main data is getting too extensive and I'd like to have some functions or automations to do that. I've tried many things but haven't got to the right solution and always end doing manually.
Anyone know what filters can I use? Any way to have that report ready to just refresh it? Thanks in advance for any help!
Answers
-
Try this as a column formula for the checkboxes...
=IF(AND([Planned Start]@row<= TODAY(28), [Planned Finish]@row>= TODAY()), 1)
This will check the box for any project that has a Start and/or end date within the next 28 days (4 weeks from today's date).
-
Thanks Paul! I'll try that. Thanks!!!
