# Sections / Tables
Sections could be used to show dynamic repeatable items usually to fill Table data with multiple columns.
#### Syntax:
```
{#[sectionName].[propertyName]}
Examples: {#people.name}, {#people.age}
{#[fieldType][sectionName].[propertyName]}
Examples: {#%people.photo}, {#*people.html}, {#!people.markdown}, {#&people.link}
```
For each section item and property passed during document generation service will automatically add additional rows to sheet and shift all the cell content down below the section cell.
Template
Output
### Formulas
You can use formulas in your sheets that refer to individual cells or table columns using relative references or named table columns. Examples:
#### Formula example in dynamic table row with named table column reference
#### Formula example in regular dynamic row with relative reference
**If you provide multiple products new rows will be added to spreadsheet, additionally:**
* The 'Cost with Tax' column with a formula will be copied to new rows, and the **formula will automatically adjust to reflect the updated relative cell references** (B4, B5, B6, etc.)
* The 'Tax' column with a static value (along with any other cells containing content in the same row) will be copied to new rows as-is.
#### Formula for table data summaries
* Use named tables to easily reference entire columns of dynamically populated table data in summary formulas.
It is not always easy to build formulas that refer to all cells in a table—such as summing all rows—when the exact number of rows or columns is not known in advance.
**Best Practices for Using Tables with Placeholders in Templates**
* **Use named Excel tables**: Define your tables using Excel’s *Insert Table* feature. When a placeholder inside a named table expands rows or columns, the table range automatically updates to include the new data.
* **Reference table data using structured references**: Take advantage of structured table references in formulas (e.g., `=SUM(TableName[ColumnName])`) to dynamically refer to entire columns, even as the table grows or shrinks.
#### Optional Columns
If you use named tables with placeholders in the header and content cells, and no value is provided (or the value is empty), those columns will be skipped in the output document. The table range will be automatically adjusted accordingly.
#### Short Definition
If you have just one table/section in your document template you can use shorter placeholder definition. **If you skip section name it will be assumed as "Items"**
```
{#name} is shorter version of {#Items.name}
{#age} is shorter version of {#Items.age}
```
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.documentero.com/documentation/sections-tables.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
