What does "Is First Column Label" do in Google Sheets widgets?
When creating a Google Sheet widget, you have the option to check or uncheck "Is First Column Label".
If you check it, the widget will show the data from your spreadsheet's first column. If, however, you leave it unchecked, the widget will add generic labels. (row 1, row 2, row 3...)
If you don't want the generic data, then check this field and the first column in your spreadsheet will be the first column in your Reportz Google Sheet widget.
NOTE: You cannot physically remove the first column, but can edit your first column in your source spreadsheet (leave it blank or whatever works best for you) and then check the "Is first column label" button.
Related Articles
Google Sheets: What are Header/Footer/Column Label Options For?
When creating your Google Sheets widget in Reportz, after choosing the Custom type of widget, there’s an option to check or uncheck the following questions: Is first row header? Is first column label? Is last row footer? These options can affect the ...
How to Add a Google Sheets Widget
Importing your Google Sheets spreadsheets into Reportz is a simple process and it only takes a couple of clicks. To create your Google Sheets widget, you should follow these steps: 1. Click on ADD DATA WIDGET, select Google Sheets as your Integration ...
How to Use our Google Sheets Template Spreadsheet
You can access our Reportz template for Google Sheets here. Important notice: This template should only be used if you would like the data in your report to be changed as you’re changing the date range of your dashboards. If you wish to present data ...
How to Set Google Sheets Dashboards to Filter your Metrics by Date Range
When connecting Google Sheets dashboards to Reportz, you have the option to filter your metrics by the date range of the dashboard. To do this, you need to format your spreadsheets in such a way so the dates are inserted in the first column (A) of ...
How to create my first dashboard?
To create your first dashboard, just follow these simple steps. Click on the Create Dashboard button Here you have 2 options: Start From Scratch or Start From Template. Creating Dashboards via the "Start From Scratch" Option First, enter the ...