Frequent questions about ProjectSheet

Can the project time be more than 10 weeks?

Yes, the time scale of the Gantt chart is independent of the project duration: the tasks table contains the start and end dates per task and the Gantt chart shows the tasks within the time scale as a bar. The project planning can therefore fall outside the Gantt chart.

Do not change the Gantt chart itself. In the sidebar under Set Gantt chart timescale you can set the start date and duration of the time scale after which the Gantt chart is updated. At the top of the list is 'Autofit' to get the entire project period in the Gantt chart.

By default, the Gantt chart shows 10 weeks of project planning from the date of today with one week per period and one day per cell. By prolonging the time scale with more weeks per period, the accuracy decreases to several days per cell because the number of cells remains the same.

What do the permissions mean I need to agree to in order to use ProjectSheet?

You need to authorize ProjectSheet once to execute functions for you in Google Drive and Google Sheets.

In detail the required permissions are:

  • Know who you are on Google
    Associate you with your public Google profile.
  • View your email address
    View the email address associated with your account. ProjectSheet needs this permission to check the Pro version.
  • View and manage spreadsheets that this application has been installed in
    Access to your Google Drive is limited to spreadsheets that ProjectSheet has been installed in.
  • View and manage data associated with the application
    ProjectSheet stores settings with each spreadsheet.
  • Allow this application to run when you are not present
    This permission allows ProjectSheet to act on changes you make in the spreadsheet like column insertion.
  • Connect to an external service
    ProjectSheet needs this permission to check the Pro version license.

How can I show the sidebar again after I closed it?

You can re-open the sidebar by going to menu Add-ons > ProjectSheet > Open sidebar.

Why can I not re-open the sidebar and only start a new project?

This typically happens if the spreadsheet layout has been modified and is not recognized anymore by the ProjectSheet add-on.

Please check the do's and dont's of customizing a ProjectSheet spreadsheet.

How can I use a template to repeatedly start a new schedule?

Make a schedule with ProjectSheet to be used as template spreadsheet.
Start a new schedule by copying this spreadsheet with menu File > Make a copy...
In this copy go to menu Add-ons > ProjectSheet > Add ProjectSheet
The copy can now be used further for a new schedule.

How can I add ProjectSheet into an existing spreadsheet?

Adding ProjectSheet into an existing spreadsheet is prevented and you will be asked to make a new spreadsheet. When you do this you can copy the ProjectSheet worksheet(s) from the new spreadsheet into the existing spreadsheet. You can now use the ProjectSheet add-on in the existing spreadsheet.
A worksheet can be copied to another spreadsheet from the menu at the tab of the worksheet.

How to remove 'task schedule' and 'resource' tab from my spreadsheet? They add automatic again when I reopen!

ProjectSheet (re)builds the tabs when they are not present. You can prevent this by disabling ProjectSheet for this spreadsheet. To do this you go to menu Add-ons > Manage add-ons... Select MANAGE at ProjectSheet and un-select 'Use in this document'. Also see Google Help.
After you did this you can delete the tabs without rebuild.

Is it possible to color each resource its own color and then color the Gantt bar with that resource's color?

A task can have more than one resource assigned, which makes it hard to choose the color.

What you can do is give each Gantt bar a color of your own choice. This is possible by giving the task description cell a background color, which is copied by ProjectSheet into the bar after you press the refresh button at the bottom of the sidebar.

You can also use Google Sheet conditional formatting for coloring resource cells at each task.

How do I activate the Pro license after payment?

By clicking in the sidebar of ProjectSheet on Pro. After activation 'Pro' will be added to the title of the sidebar.

Clicking on Pro again after activation will give the end date of the license period.

How can someone else pay for your license?

Order the license in ProjectSheet yourself to be certain that the license is for your Google account. As soon as you reach the PayPal Buy Now button, underneath use right-click to copy link to copy the PayPal link. You send the link to the person who is going to pay with his PayPal account. After payment you activate the license by clicking Pro in the sidebar.

Note: Do not use the link you get when clicking on Buy Now.