The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
I have a report section in a sight including a GANTT chart. The report itself displays the GANNT starting at the first task start date or today with the GANTT paramter. When viewing the sight, the GANNT always seems to start in January. This particular project starts towards end of year so I have 10 months of empty space in my sight losing and not being able to view the whol chart.
The Report Widget will currently put the Gantt chart at the start of the first project from your source sheets.
You might want to consider creating a report that more narrowly depicts the project you need displayed in your Sight, possibly using a shorter date range in the "When?" criteria.
If the above doesn't help, contact our Support team at[email protected]to further isolate the behavior.
Shaine - for the life of me I can't see how you would use the 'When' criteria to drive the correct display of the Gantt view in the Sight. The report builder seems to just select rows to display. It doesn't control the slice of the Gantt view needed. The Gantt view on/off tool in the Sight edit function needs something similar to the project settings/timeline display options in the gantt view for Sheets and Reports. All that said I'd be happy to be told I've got it wrong.
Mark, Was this ever answered or did you figure it out. I'm new to Smartsheet and I am experiencing the same issue. I don't see any way to resolve this?
I can't remember the exact sequence of events now. However, I did get this solved.
In my case I have a schedule sheet, which has a 'For reporting' checkbox column on each row. That let's a project manager manually select what they'd like to report upwards and removes the noise for exec reporting.
To feed the Sight correctly I have a report which selects on the checkbox field in the schedule, and a reduced set of columns to display. The report 'When' parameter can be used on the 'Start' column date as necessary. Just set it to 'Greater than' the starting point you want. In most cases we don't now need it as the manual 'For reporting' decision often eliminates the need however it does work when required (I wish I could set it based on a field in the sheet though!).
The Sight then picks up the report with it's parameters and formatting.
\"//www.santa-greenland.com/community/discussion/comment/\", [Project Lead]:[Project…","snippet":"This formula is currently working, and it is returning how many items are reviewed for each \"Project Lead\". The first part of the formula is basically saying that we would count…","categoryID":322,"dateInserted":"2023-06-29T22:39:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157974,"lastUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3376173036,"url":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","format":"Rich","lastPost":{"discussionID":107113,"commentID":383252,"name":"Re: How to return a BLANK if we have a BLANK cell using a COUNTIFS formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383252#Comment_383252","dateInserted":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T02:51:53+00:00","dateAnswered":"2023-06-29T22:55:01+00:00","acceptedAnswers":[{"commentID":383233,"body":"
Shaine Greenwood Employee
