-
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
-
Weeks Out Calculation based on Nested IF Statement
I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer…
-
multiple date columns
i have created a sheet that has a notification date column and then a start date column and then an end date column. i only want the ghant chart to pick up the start and end date columns and not the notification date column. how do i do this???
-
% allocation
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
-
30-Day Prompt
Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…
-
Converting Numeric Values to Days
Hi, I would like to input a quantity in a cell and use a formula to convert it into days of production. I have accomplished this with the exception of the Duration column does not convert the numerical value into days for the Gantt chart. Please help. Thank you, Dennis
-
Highlighting Gantt Chart Information
Hi, Is it possible to highlight multiple blocks on a gantt chart at the one time without having to CTRL+ each individual block? Thanks Emma
-
Filtering Gantt chart on mobile app
Hi I have a sheet with a number of preset filters, and on my pc, i can apply the filter on the Gantt chart views, while this does not seem possible on the IOS application. Anybody can help with how to do this on the mobile app? Thanks Eid
-
Option to Open to Today's Date not saving
Hello, Not sure if anyone else has seen this but when I select the Timeline Display option to Open to Today's Date, the option doesn't save. I need to select the option each time I open the sheet. Seems like a bug or I'm missing something. Thanks
-
Show ONLY 1 Project's Gantt in a Sight
I am building a Sight for just 1 project. It has the project's title, an overall report, and then a report that shows just the status comments. The last widget I want to put on the Sight is JUST the Gantt chart for that particular project. How do I show that?