In a new sheet I'm creating the Gantt view background cell color (not the task bar) is dark blue making it very difficult to read anything. I can't see any option to change this. Can anyone point me in the right direction? Thanks
I am trying to get data for a sheet which is repesented in the Gantt View. Since the ganttview already shows all the milestones and tasks that are under the milestones, getting that data would reduce our calculation by a huge chunk. any idea how can I do this via the api? The get sheets endpoint has include=ganttConfig but…
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
I'm expecting my next project to be subject to a lot of external influences and dependencies. When faced with this challenge I like to show the original plan and the actual / newly forecast start and end dates to report upwards effectively and discuss the any slip. So in effect each activity has an "originally planned"…
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
Hi How can we prepare the baseline chart to show each projects Original schedule and current schedule . Thanks
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique…
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on. So what I'm looking for is…
Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
