Rolling Dates in a report
Hello.
I have a project sheet to track individual projects. Each project is a separate row in the sheet, with a Start date, a Duration and a calculated Finish date. New projects (new rows) are added to the sheet via a form that that can be used by anyone from our web page. When the for form is submitted with a new project, a new row is added to the project sheet.
I provide visibility of the projects through a report on a dashboard. I would like to the report to only pull projects that have a 6 month moving window. I would like to identify all projects that are submitted, starting or finishing during the past 90 and the future 90 days.
I know the Report Builder allows you to select Finished dates in the last 90 days, or Finished days i the next 90 days, but it will not allow you to do both. The same applies for using the start date.
I hope this makes sense. Thanks for any help.
Tim Jensen
Comments
-
I tested this myself, and was able to get both in. See the attached as a sample. If you're still unable to get it to work, could you share a screenshot of your report criteria?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives