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.
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
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.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.