-
Gantt chart - date fields ok from formulas?
Hi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns but they are derived from formulas. Does the Gantt chart functionality not recognize…
-
Gantt View data for sheet via api
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…
-
Total Cost Based on Date of Task Being Finished
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…
-
Planned dates and actual visible on Gantt chart
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"…
-
Integrating Gaant View Items and Calendar View
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…
-
How can we create baseline chart
Hi How can we prepare the baseline chart to show each projects Original schedule and current schedule . Thanks
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
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.
-
Conditional search and return
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…
-
Formula for RYG for Project Schedule Status
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…
-
Rolling up multiple projects onto a dashboard
Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
