Reports - restrict date range

Hi,

Is there a way to restrict the date range on reports with the gantt view? i.e. I only want to see the next 3 months, next 9 months etc.

Thanks!

Find more posts tagged with

Reports

Gantt View

Project Management

Comments

Mick Jordan

Hi, how about trying a formula in a checkbox column such as =IF(Start1 < TODAY() + 90, 1, 0) You can then configure the report to filter for that checkbox being ticked only.

You will need to enhance the formula to take into account tasks that start within the 90days but finish beyond it.

Repeat the process for 9 months etc.

Hope that helps

Mick

Thanks Mick.

Yes I've considered using formulas to create a workaround as you've done using if and today statements, but the requirement is slightly different than what you have in mind and won't work for a few reasons.

Sign in to join the conversation!

Quick Links

Trending discussions

Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
Is there a way to update scaling on Smartsheet Dashboard graphs?
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
Automation problem
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…