Project look ahead

John Kelly

Hi, I am looking to add a widget to a dashboard to show a two week look ahead of a project. I have a project sheet and essentially want to create a formula to check a box, from which I can use to trigger a report.

Paul Newcome

Try adding this to a checkbox column (make sure you update column names as needed):

=IF(AND([Start Date]@row <= TODAY(21), [Finish Date]@row>= TODAY()), 1)

You can then either filter or build a report based off of this checkbox column.

Paul Newcome

Are you wanting to look at start or finish date or both?

John Kelly

Both really, I am looking to give management a 3 week summary of tasks for the coming 2 weeks, or whatever timescale they decide. I want to grab a snapshot of the next 2 weeks on a project.

Paul Newcome

Try adding this to a checkbox column (make sure you update column names as needed):

=IF(AND([Start Date]@row <= TODAY(21), [Finish Date]@row>= TODAY()), 1)

You can then either filter or build a report based off of this checkbox column.

John Kelly

Perfect, thank you

Paul Newcome

Happy to help! 👍️

Jace Jontz

I have the same request and I don't see what you ended up doing. Is the red box your look ahead area? How did you create this box?

Thank you,

Jace

Paul Newcome

@Jace Jontz The red box is just an overlay of the screenshot to highlight which date range they were wanting to filter on. The solution can be found in the "Accepted Answer" at the top of this thread.

Jace Jontz

Thank you Paul. Looking at it now!!!