-
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?
-
Gantt chart changes to quarters instead of months when printed
How do I export to pdf and show months instead of quarters? I am only seeing my gantt chart as quarters.
-
Creating dependancies so I can change my start date
I am setting up a project plan but at this time I am not sure what my start date is. I can set it up with a possible date and create my tasks and dependnacies. But how can I make sure my dependancies are set up correct so that when I change my start date everything will fall into place.
-
Gantt View - % Complete Column
I've noticed that to have the "% complete" column value show up graphically within the Gantt display, the "% complete" column MUST be a free-form entry field. I have another sheet column that uses the "Progress Bar" type. I was hoping to make the "% complete" column calculated based on the value within the "Progress Bar"…
-
Ghant Chart with quarter headings
I really like the quarterly level ghant chart. However, when the earliest task begins near the end of the quarter, I have two months of blank ghant. I thought that I could force it to show only the part of the quarter that has a task by specifying a date range. But, I still get the blank part of the quarter. Is there any…
