-
Completion Status Bar with the Task Bar
This is a fairly straight forward question and I think I might know the answer, BUT here it goes. The completion status bar within the task bar is typically driven by the % Complete column. It appears that column (for the bar to work correctly) has to be manually entered. If I use a formula, it will give me a % but will…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
Dashboard Gantt for Extended Period Task Prevents Display of Current Dates
For a leadership dashboard, we have a report with a list of current projects. We want to display the Gantt chart on a dashboard. One of the projects began on 8/4/2015. The Gantt timeline begins in August 2015 and can scroll to the week of March 17, 2019. Given that it is May 23, 2019, this is a no-go. Workaround ideas? My…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Indenting sub-sub-tasks remove Gantt bars (start and finish dates)
Adding sub-tasks to a task seems to be no problem, perhaps because they are already indented. Indenting these sub-tasks removes all the start and finish dates for the rest of the sheet. Is there a way to avoid this and preserve the Start and f=Finish dates, thereby saving the Gantt chart? One way is to copy and past the…
-
Gantt Chart Printing with Current Date
Is there a way to print the current date dashed line that appears in the Gantt chart view on the screen when printing to a pdf? Having that visual cue would really help when printing this out for others. Thanks. Ryan
-
Gantt Task Completion bar based on dynamic % Complete
Is there a way to set a dynamic column to be the % Complete column for the purpose of setting the Task Completion bar? All help is appreciated.
-
Maintain dependencies on drag and drop in GANTT view
Hello, I have a support request on drag and drop dependencies. * SMARTSHEET changes the date, if I drag the predecessor bar to the successor bar * SMARTSHHET looses connection of dependencies if I move a connected bar left or right This "simple" described problems can be fixed manually by myself but it's annoying,…
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…