Structured references
Add structured data to Spreadsheet and reference them using semantic formulas
Last updated
Add structured data to Spreadsheet and reference them using semantic formulas
Last updated
Spreadsheet allows you to convert any data in the sheet to an Excel Table. Select a dataset, or add a dataset using an Array formula such as =IMPORTDATA
You can now add formulas in your table referencing to the column names
Dynamic columns can be added just like Excel. Users can edit the table, add multiple columns and extend the table range to give the column additional features such as filtering, sorting etc
You can join tables and create dynamic columns from multiple datasources. Structured formulas refer tables using Table name . For example, in the above table, you can add formulas like =Table 2[@Region]
