Frequent questions about ProjectSheet

This is because you are logged in with multiple Google accounts. The sidebar sometimes uses a different account than the spreadsheet, which is a Google known issue. Using the browser's incognito window and logging in there is the recommended workaround.

Please click on the star to urge Google to solve this issue.

Some actions take time for calculation, like inserting new tasks or changing dates. In the tab at the bottom of the sheet you see "Please wait..." to indicate this.

In the Pro version you have an additional column called Days, containing the duration of a task. To move a task to a later date, in Pro you simply change the Start date and Pro calculates the new Finish date based on the number of Days, taking into account weekends and holidays. There is no need to change the Finish date yourself.

You need to authorize ProjectSheet once, so it can execute functions for you in Google Sheets.

In detail the required permissions are:

• View and manage spreadsheets that this application has been installed in
  Access to your Google Drive is limited to spreadsheets that use ProjectSheet.
• Connect to an external service
  ProjectSheet needs this permission to check the Pro license.
• 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.
• Display and run third-party web content in prompts and sidebars inside Google applications
  ProjectSheet is a regular add-on that runs code and stores settings with each spreadsheet.

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 don'ts of customizing a ProjectSheet spreadsheet.

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

If the above does not work, there may be an issue due to Google changing the marketplace in the middle of 2019 where you got the add-on. This intermediate position can be resolved as follows:

1. Install ProjectSheet add-on from Google Workspace Marketplace
2. Then, remove it with Manage apps
3. Finally, open the spreadsheet and remove the add-on again.

It does but in a very limited way. A ProjectSheet function performs many spreadsheet functions which all need to be undone separately. Only functions which do not involve ProjectSheet can be undone with one click. Examples are color and layout.

As an alternative to Undo you can restore a previous version. In The File menu go to Version history > See version history, select the desired version and click the green Restore this version button.

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.

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.

Without a ProjectSheet Pro license you can only edit a shared ProjectSheet Pro schedule with the standard features and non-Pro columns will get a strike-through automatically. A non-Pro user needs to know what he can and cannot edit in a shared Pro schedule in order to have effect, which has a risk for confusion.

Sharing for viewing is safe to avoid confusion in all cases. For viewing of the shared spreadsheet, the installation of ProjectSheet is not required. Sharing for editing is safe as long as you share with users who also have a Pro license, such as within a Pro for Domain license.

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

Do not change the Gantt chart in the spreadsheet itself. In the Sidebar Settings under Gantt chart timescale you can set its Start date and timescale unit. By changing the Start date, you can scroll through the Gantt chart. By default, the Gantt chart shows 3 months (13 weeks) of project planning with one day per cell.

Changing the timescale unit is available in ProjectSheet Pro. The timescale unit, expressed in time per period, determines the total time span of the timescale. At the top of the timescale units list is the 'show entire project' function to get the entire project in the Gantt chart. By increasing the timescale unit, the accuracy decreases to several days per column, because the number of columns remains the same.

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

Add ProjectSheet to an empty Google spreadsheet to be used as a Template.
You can add template tasks, resources (Pro) or holidays (Pro).
You can also add sheets of your own.
Start a new project by copying this Template with menu File > Make a copy...
The copy can be used for the new project.

The Pro version sets start and finish dates combined with time, unlike date-only as in the free version. You can see the time of a date cell in the formula bar of the spreadsheet. The time is based on 24 hours for a full working day in order to be able to work with decimal task duration days. To convert to your own working period in a day, you insert a column to contain the actual working time per start and finish column. In these columns you add cell formulas to get the time part and do the time conversion:

=start_time/24 + MOD(<reference to cell in date+time column in same task row>; 1)/24*working_hours_per_day

You best format the inserted columns as time and keep the original column formatted as date.
See example below for start_time=6 and working_hours_per_day=10.

Here you can read what you can and cannot customize in a ProjectSheet spreadsheet.

You can make a snapshot of the schedule and share a link to it using following steps:

1. Hide the columns and/or rows you do not want to show.
2. Go to menu File > Publish to the web.
3. Uncheck "Automatically republish when changes are made".
4. To publish changes, first Stop and then Start publishing again.
5. Give the published unique URL to your client, see also https://support.google.com/docs/answer/183965.

Only after activation, the Pro functions will become available, also with an extension. This is true for each account in a domain license as well. By clicking in the sidebar of ProjectSheet on Pro info, 'Pro' will be added to the title of the sidebar.

Make sure you activate with the same account you used during the purchase and which is mentioned on the invoice. Activation needs to be done only once per license period.

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

With ProjectSheet Pro, Pro-specific columns are added. Without a valid Pro license these columns can get a strike-through later. This might be the case when your license has expired or a new license has not been activated yet.

You may also get strike-though columns when the spreadsheet was shared for editing with an account that has no (activated) Pro license. As soon as this other account opens the spreadsheet, the strike-through appears. Sharing for viewing will not give this effect.

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 with PayPal button with your mouse, use right-click/b> to copy the link from the context menu. You send the link to the person who is going to pay with his PayPal account. After payment, you activate/extend the license by clicking Pro info in the sidebar.