-
Embed certain columns on another page?
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
Automating a Gantt chart from Jira Kanban in early planning
The execs want a Gantt chart from my Kanban board. I will be using the Jira/SmartSheet connector for this task. Here is my current thinking: * Take the total number of tasks and divide by the available work time to create an average size if the tasks completely fill the time (the SME who will be sizing the items has not…
-
Move Project with Predecessors
I need help moving a project that has predecessors. This is being used for a production facility to track the status of our projects. However, I have run into a problem when needing to move a project in the order of production. The predecessors are not moving with the project change. -I need the "Design" process of the…
-
ProChain Like functionality
Is there a plug-in type app for critical chain or theory of constraints? I have used MS Project with ProChain and like the fever charts and buffer provided based on focused and low risk inputs. Thanks in advance.
-
Timeline Display Dates Before Project Start
Im new to SS. Does anyone know how to change the setting on the gantt timeline display to start the day of the project. I've played around with the primary and secondary headings but the timeline still prints before the project start date. Example: My project started on 12/30/15 but the timeline starts on 12/1/15.
-
Constraints in predecessors in SmartSheet ?
Hi, I want to create the gantt with schedue as below: Task A Subtask A1 Oct 15 to Oct 19 Subtask A2 Oct 15 to Oct 19 Subtask A3 Oct 22 to Oct 26 Subtask A4 Oct 29 to Nov 2 Predecessors of A3 = Subtask A1 and Subtask A2 Predecessors of A4 = Subtask A1 and Subtask A2 Subtask A3 and Subtask A4 are assigned to the same…
-
Stacked Charts
Hello 1. I am new to the smartsheet community and would like to know if it is possible to plot dates using the charts widget in the dashboard. I intend on plotting a stacked bar chart with dates and duration. (As show in Figure 1) 2. While using the clustered bar charts option, is it possible to a merge the bars, something…
-
Project tasks in order but not date dependent
I am trying to set up a sheet that uses a gantt chart to track the timeline for a project with multiple steps that must occur in order. My goal is that the tasks must be completed in order and nothing can be done on the task until the previous task is signed off as completed by the owner. Ideally there would be an alert to…
-
Help with Weighted Average w/ a Nested If Function
I have a Text/Number Column with the following nested 'IF' function generated Percents based on a status column: IF(Milestone3 = "Proposed", "0%", IF(Milestone3 = "In Progress", "10%", IF(Milestone3 = "Assigned to QA", "20%", IF(Milestone3 = "QA in Progress", "30%", IF(Milestone3 = "Ready for Staging", "40%", IF(Milestone3…
-
Critical Path Not Showing up
Hello, The critical path for my project is not displaying properly. It only highlights a few tasks while it should be highlighting many more. I have predecessors and duration enabled, and I have looked through the forums to try to fix the problem. One possible answer may be that the timeline has paths in parallel. Is there…