Project look ahead
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.
Best Answer
-
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.
Answers
-
Are you wanting to look at start or finish date or both?
-
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.
-
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.
-
Perfect, thank you
-
Happy to help! 👍️
-
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
-
@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.
-
Thank you Paul. Looking at it now!!!
Help Article Resources
Categories
Check out the Formula Handbook template!
