-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Start always today's date?
Is there a setting to always have the start date as todays date and the end date does not chang? Thanks in advance. Grant
-
date trigger formula
Im wondering if there is in smartsheet formula that can transfer task name to another sheet when the date is today?
-
Multi-Layer Gantt Chart
Hello, I'd like to create a Gantt chart which allows me to layer an original date range and an actual date range. This way, I would be able to show how a schedule has changed against an original base line. Ideally, i'd like to be able to see the original date as one color, and the actual date as a slightly different color,…
-
#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…