The Project Sheet is broken, what happened?

There are a couple rules to follow to ensure that your Project Sheet works well. Here are a few examples of what can go wrong, and how to fix it.

An automated field has been filled manually

A lot of fields are automated in the Project Sheet. This is indicated by the column header, as shown in the screenshot below.

If an automated field is accidentally filled manually, the Project Sheet will start malfunctioning.

In the example below, someone filled cell E12 with some data, although column E is automated. As a result, the Project Sheet does not display data correctly anymore

In order to fix it, delete the content of Cell E12. After a few minutes, the Project Sheet will function normally again, as shown in the screenshot below.

Note: The same principle applies to all automated fields. If you notice a Project Sheet malfunction, check all automated fields and make sure nothing has been filled in manually by mistake.

I accidentally deleted a line

It is common to want to delete a line if its information is not needed anymore. However, this is not the correct method to use in the Project Sheet.
Instead, the line’s status must be set to Cancelled, as shown below

So what happens if a line is deleted by mistake? In this example, Content ID 105 has been completely deleted.

In order to fix this, we will re-create a line with Content ID 105 at the bottom of the list, fill it with placeholder data, then cancel it.

This will allow the Project Sheet to update everything correctly in the backend, preventing any further issues.