-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Smartsheet Workspace to excel using the connector
Before upgrading to the next tier (where the connector exists), I want to make sure what I want to do is possible. Can the connector pass an entire workspace to Excel, rather than individual files. There is a workspace that contains many gantt chart files and an easy to view row summary of each chart is wanted such that it…
-
Working with dependencies is a nightmare
Dear Smartsheet, I have a two change requests, because at the moment working with dependencies is really inefficient and time consuming: 1. Auto calculate lag when creating dependencies: when I create a dependency it automatically changes start or end dates. This is very annoying and time consuming because you always have…
-
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…
