> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://doc.common-services.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Some examples

You can edit the data directly in the sheet itself, but for analysis purposes, we recommend that you create a new sheet, in this way, in case of an update of the application or if you have the intention to delete your sheet to recreate a new one, you will be able to move your formulas from the old sheet to the new one.

Here are some samples with VLOOKUP formula and pivot tables;

https://docs.google.com/spreadsheets/d/182mO42ySYhZnrRpLw8Xl8_D1WGSuzIMtWizwoHUxZ_M/edit?usp=sharing

How to create a new Google Sheet sheet and import the data dynamically linked to the sheet created by the App:

* Create a new sheet on Google Sheets
* Import the data into the tab with IMPORTRANGE:

![](https://storage.crisp.chat/users/helpdesk/website/-/3/f/a/8/3fa8ee645cd13200/image_ohu0zj.png)

Then create a new sheet to display consolidated data;

![](https://storage.crisp.chat/users/helpdesk/website/-/3/f/a/8/3fa8ee645cd13200/image_1uv6r98.png)

https://docs.google.com/spreadsheets/d/1QoDtMTvhilIvuIQTNrKP4qEa4M2QEgGH1V-vbH5ax88/edit#gid=931443235

Every time the app updates its sheet, the external sheet will also be automatically updated!