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…
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 =…
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 looke…
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…
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 …
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…
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 ta…
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?
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 she…
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…