-
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.
-
No Bars
I have imported a checklist from excel, set it up as a Gantt (transposed columnar hierarchy,) put in predecessors, and durations. No bars appear on the chart. What's up with that?
-
Complete % on parent task and sub tasks
Just discovered this on project sheet and was wondering what could have caused it? One parent task in my sheet is showing the value "1" when a subtask is set to 100% Other parent tasks in the same sheet is showing 100% when the sub tasks are set to 100%. A bug or RTFM?
-
Help with Gantt chart -- only two bars showing
I created a timeline and when I chose Gantt view only two bars on the Gant chart are showing even though I have probably 25 tasks. I have a beginning and end date for all tasks. How do I get the items to show on the Gantt view? Screenshot attached. Many thanks for any help.
