> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos.md).

# How-tos

- [Measure and row-based planning](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning.md)
- [Insert data input columns](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns.md)
- [Insert column - Fundamentals](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-fundamentals.md)
- [Insert column - Number](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-manual-input-columns.md)
- [Insert column - Text](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/text-checkbox-and-date.md)
- [Insert column - Checkbox](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-checkbox.md)
- [Insert column - Person](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/writeback-matrix-features.md)
- [Insert column - List](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/dropdown.md)
- [Insert column - Date](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-date.md)
- [Insert column - Formula](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-calculated-columns.md)
- [Insert column - Simulation](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-simulation.md)
- [Measure-based modeling](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/measure-based-modelling.md)
- [Cubes](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting.md)
- [Plan across multiple dimensions with cubes](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/allocate-values-across-dimensions.md)
- [Multidimensional expense allocation](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-expense-allocation.md)
- [Multidimensional forecasting](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-forecasting.md)
- [Cube best practices and FAQs](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/cube-best-practices-and-faqs.md)
- [Manage cube measures](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/manage-cube-measures.md)
- [Insert data input rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows.md)
- [Insert rows - Fundamentals](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-manual-input-rows.md)
- [Insert template rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/template-rows.md)
- [Insert formula rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-calculated-rows.md)
- [Insert blank rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-blank-rows.md)
- [Insert forecast rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-forecast-rows.md)
- [Manage inserted rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/manage-inserted-rows-and-columns.md)
- [Row-based modeling](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling.md)
- [Create a row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-a-row-model.md)
- [Create forecasts using row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-forecasts-using-row-model.md)
- [Perform scenario analysis in row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/perform-scenario-analysis-in-row-model.md)
- [Configure row properties in a row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/configure-row-properties-in-the-model.md)
- [Create row model templates](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-templates-for-reusable-row-structures.md)
- [Tree view](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/tree-view.md)
- [Forecast data to predict future trends](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md)
- [Create a P\&L forecast](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-a-p-and-l-forecast.md)
- [Create multi-dimensional forecasts](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md)
- [Manage rolling forecasts](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts.md)
- [Generate Statistical Forecasts using PREDICT feature](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data.md)
- [Extend planning beyond source data periods](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods.md)
- [Edit forecast settings](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md)
- [Allocate deficits to meet targets](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets.md)
- [Forecasting FAQ](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/forecasting-faq.md)
- [Collabration and export](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export.md)
- [Commenting and collaboration](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/commenting-and-collaboration.md)
- [Export data](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/exports-in-the-planning-sheet.md)
- [Persist data with Writeback](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback.md)
- [Writeback in Plan](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/writeback-in-plan.md)
- [General Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/general-settings.md)
- [Data Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/data-settings.md)
- [Destination Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/destination-settings.md)
- [Configure advanced settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-advanced-settings.md)
- [Configure writeback destinations](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-writeback-destinations.md)
- [View Logs](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/view-logs.md)
- [Enable writeback in reading mode](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/enable-writeback-in-reading-mode.md)
- [FAQs on Writeback](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/faqs-on-writeback.md)
- [Analyze planning outcomes with scenarios](https://docs.fabricplan.com/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios.md)
- [Pivot data](https://docs.fabricplan.com/planning-sheets/how-tos/pivot.md)
- [Format and display](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display.md)
- [Layouts](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/layouts.md)
- [Conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting.md)
- [Create rules in Conditional Formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting.md)
- [Format by Rules (If conditions) in conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting.md)
- [Page 1](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/page-1.md)
- [Format by Color scale conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting.md)
- [Format by classification conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting.md)
- [Quick formatting options](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/quick-formatting-options.md)
- [Manage Rules](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/manage-rules.md)
- [Add notes in a planning sheet](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/notes-in-commenting-and-collaboration.md)
- [Basic formatting](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting.md)
- [Number formatting](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting/number-formatting.md): Plan for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table/matrix style reports.
- [Cell, header & value formatting](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting.md)
- [Total and Subtotals](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting/total-and-subtotals.md)
- [Adding business logic and formulas](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae.md)
- [Edit cells](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells.md)
- [Measures and Columns](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns.md)
- [Importing data](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/importing-data.md)
- [Invert sign](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/invert-sign.md)
- [Pivot data](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/pivot-data.md)
- [Optimize overview](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview.md)
- [Maximize or minimize a target value](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview/maximize-or-minimize-a-target-value.md)
- [Optimize input values to meet a target](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview/optimize-input-values-to-meet-a-target.md)
- [Use Optimize on derived measures and allocation rules](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview/use-optimize-on-derived-measures-and-allocation-rules.md)
- [Configure approval workflows](https://docs.fabricplan.com/planning-sheets/how-tos/configure-approval-workflows.md)
- [Connected planning](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge.md)
- [Create a bridge to integrate and transform plans](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/1.-create-bridge.md)
- [Blend measures by using Infobridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/blend-measures-by-using-infobridge.md)
- [Import data into a bridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/2.-add-source-to-bridge.md)
- [Manage query operations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/4.-manage-queries.md)
- [Manage sources](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/manage-sources.md)
- [Share measures](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/share-measures.md)
- [Consolidate data between sheets](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/import-measures-between-planning-sheets.md)
- [Use dimension level](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/use-dimension-level.md)
- [Data transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations.md)
- [Use pivot table](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-table.md)
- [Group by transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/group-by.md): Learn how to aggregate and summarize detailed reports with the Group by transformation.
- [Add Column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/add-column.md)
- [Pivot and unpivot columns](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-columns-unpivot-columns.md)
- [Rename column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/rename-column.md)
- [Use Find and Replace](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/find-and-replace.md)
- [Remove column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/remove-column.md)
- [Filter rows](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/filter-rows.md)
- [Sort](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/sort.md)
- [Text functions](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/text-functions.md)
- [Unnest](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/unnest.md): Learn how to use the Unnest transformation to convert delimited values into separate rows and flatten your data.
- [Round](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/round.md)
- [Extract Comments](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/extract-comments.md)
- [Import and export transformation steps](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/import-and-export.md)
- [Query transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations.md)
- [Append Queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/append.md)
- [Join queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/join.md): Explore how to leverage joins to retrieve data from multiple tables using a related column.
- [Merge queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/merge-queries.md)
- [SQL queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/sql-queries.md)
- [Duplicate a query](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/duplicate-a-query.md)
- [Writeback transformed data from InfoBridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/writeback-transformed-data-from-infobridge.md)
- [Manage security in planning](https://docs.fabricplan.com/planning-sheets/how-tos/manage-security-in-planning.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.