-
#REF in Predecessors
What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't…
-
Critical path disappeared
I was updating a project gantt chart and at some point the critical path red outline disappeared (no I didn't turn it off, I checked!) What is required that this is visible? I had to break some task dependencies to get the bars to actually show real-world dates, could that be it?
-
Report Widget in Dashboard
Is there a way to share the Gantt chart separately in a dashboard without showing the report? Because of the current layout, both are included in the same widget and you have to scroll to see all the information on either one. Previous discussions regarding this topic indicated that changes were pending. Is there any…
-
Start Date & End Date in Minutes, Hours, and Weeks
Many thanks for the "Duration in Minutes" update. I also wonder if there is a way to enter Start Dates and End Dates in Minutes, Hours, and Weeks; too. For example; I have a task which starts at the 3rd hour of a workday and no predecessor task to it; but another task before it which ends at the 3rd hour.
-
Calendar view from multiple sheets
HI I am new to Smartsheet and I basically want to use Smartsheet to create a schedule for my business and life to be seen in a calendar and Gantt view. Before creating my sheet/s I am in a dilemma if to create a different sheet for about the seven different projects constituting my business, or to create one sheet. The…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Revising duration so it doesn't count first day
I want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column. This is because day 1 is the first day, when I need "day 1" to be the following date from the first day. Is there any easy way to fix this? In my job I can never count the first day as day one as…
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Problem with Gant Chart - Gear Icon not consistently shared
Hello All, The gear icon that I see in my gant chart schedule, is not showing up for certain people that I share the sheet with. This is a problem as our project managers need to be able to change the time line displays. Some people can see it, some people cant. I can not find the setting to always allow the gear icon to…
-
Gantt charts open at earliest date for collaborators
Is there any way to have collaborators being able to open gantt charts at today's date instead of the earliest date?
