-
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…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
FS date calculation issue
I have the following calculated task dates in a gantt chart: Task no. Duration Early start Early Finish Dependency 22 60d 1-Feb-2021 23-Apr-2021 23 60d 29-Jan-2024 19-Apr-2024 22FS+720d (See attached screenshot) Task #23 is supposed to start 720d after #22 has finished. But if you manually check the number of days between…
-
How Smartsheet define, handle and monitor allocation on teammember
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…
-
Assign a task to more than one person?
Is there a way to assign more than one person to a task without having to create a whole new separate row or splitting the task into multiple tasks? It seems a bit messy to do so if I have a lot of tasks that will need multiple resources.
