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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you wanting to look at start or finish date or both?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Perfect, thank you
-
Happy to help! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul. Looking at it now!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!