> 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/documentation.md).

# Documentation

- [Plan](https://docs.fabricplan.com/documentation/readme.md): No-code, Full-stack Planning + BI + Data Management Suite on Microsoft Fabric
- [Prerequisites for Plan](https://docs.fabricplan.com/documentation/readme/prerequisites-for-plan.md)
- [Known Limitations in Plan (Preview)](https://docs.fabricplan.com/documentation/readme/known-limitations-in-plan-preview.md)
- [Row-level security (RLS) behavior in Plan](https://docs.fabricplan.com/documentation/readme/row-level-security-rls-behavior-in-plan.md)
- [Roles in Fabric Plan](https://docs.fabricplan.com/documentation/readme/roles-in-fabric-plan.md)
- [Role upgrades](https://docs.fabricplan.com/documentation/readme/roles-in-fabric-plan/role-upgrades.md)
- [Disaster recovery for Plan](https://docs.fabricplan.com/documentation/readme/disaster-recovery-for-plan.md): Experience-Specific Recovery Procedures for Planning in Fabric IQ
- [Planning sheets](https://docs.fabricplan.com/documentation/readme/planning-sheets.md)
- [How-tos](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos.md)
- [Get started with Planning sheets](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/get-started-with-planning-sheets.md)
- [Create and share a cloud connection for a semantic model](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model.md)
- [Create a database connection](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-a-database-connection.md)
- [Creating a Planning Sheet](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/creating-a-planning-sheet.md)
- [Create a database connection for collaboration](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-a-database-connection-for-collaboration.md)
- [copy of Create a connection for semantic models](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/copy-of-create-a-connection-for-semantic-models.md)
- [Create and share a cloud connection for a semantic model-sp](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model-sp.md)
- [Forecast data to predict future trends](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md)
- [Create multi-dimensional forecasts](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md)
- [Manage rolling forecasts](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts.md)
- [Generate forecasts from statistical data](https://docs.fabricplan.com/documentation/readme/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/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods.md)
- [Edit forecast settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md)
- [Allocate deficits to meet targets](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets.md)
- [Commenting and collaboration](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/commenting-and-collaboration.md)
- [Notes in Commenting and Collaboration](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/commenting-and-collaboration/notes-in-commenting-and-collaboration.md)
- [Extend Planning sheet with data input](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/extend-planning-sheet-with-data-input.md)
- [Plan across multiple dimensions with cubes](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/allocate-values-across-dimensions.md)
- [Analyze planning outcomes with scenarios](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios.md)
- [Bookmarks](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/bookmarks.md)
- [Exports in the Planning sheet](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/exports-in-the-planning-sheet.md)
- [Pivot](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/pivot.md)
- [Layouts](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/layouts.md)
- [Conditional formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting.md)
- [Create rules in Conditional Formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting.md)
- [Format by Rules (If conditions) in conditional formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting.md)
- [Page 1](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/page-1.md)
- [Format by Color scale conditional formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting.md)
- [Format by classification conditional formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting.md)
- [Quick formatting options](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/quick-formatting-options.md)
- [Manage Rules](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/conditional-formatting/manage-rules.md)
- [Persist data with Writeback](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback.md)
- [Writeback in Plan](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/writeback-in-plan.md)
- [General Settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/general-settings.md)
- [Data Settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/data-settings.md)
- [Destination Settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/destination-settings.md)
- [Configure advanced settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings.md)
- [Configure writeback destinations](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-writeback-destinations.md)
- [View Logs](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/view-logs.md)
- [Enable writeback in reading mode](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/enable-writeback-in-reading-mode.md)
- [FAQs on Writeback](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/persist-planning-data-using-writeback/faqs-on-writeback.md)
- [Layout options](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/layout-options.md)
- [Basic formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/basic-formatting.md)
- [Number formatting](https://docs.fabricplan.com/documentation/readme/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/documentation/readme/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting.md)
- [Total and Subtotals](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/basic-formatting/total-and-subtotals.md)
- [Adding business logic and formulas](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae.md)
- [Edit cells](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells.md)
- [Rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows.md)
- [Insert data input rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md)
- [Insert template rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/template-rows.md)
- [Insert formula rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows.md)
- [Insert blank rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-blank-rows.md)
- [Insert forecast rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows.md)
- [Measures and Columns](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns.md)
- [Insert data input columns](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns.md)
- [Number](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns.md)
- [Dropdown](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown.md)
- [Dropdown options from semantic models](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown/dropdown-options-from-semantic-models.md)
- [Lookup visuals for dropdowns](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown/lookup-visuals-for-dropdowns.md)
- [Text, checkbox & date](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/text-checkbox-and-date.md)
- [Person](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/writeback-matrix-features.md)
- [Importing data](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/importing-data.md)
- [Insert Formula columns](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-calculated-columns.md)
- [Importing data](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/importing-data.md)
- [Invert sign](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/invert-sign.md)
- [Quick formula](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/quick-formula.md)
- [Visual column inside visual measures](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/visual-column-inside-visual-measures.md)
- [Manage inserted rows](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns.md)
- [Manage inserted measures & columns](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns-1.md)
- [Manage aggregation](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation.md): Custom Measure Aggregations in Semantic Models with Plan
- [Row aggregation](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation/row-aggregation.md)
- [Pivot data](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/pivot-data.md)
- [Conditional formatting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting.md): Plan enables intuitive data classification using conditional formatting, allowing users to visually interpret performance at a glance
- [One-click options](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/one-click-options.md)
- [Create rule](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings.md): You can build your own conditional formatting rules from scratch or customize the rules created using the one-click options if your report requires it.
- [Rules (If conditions)](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/rules-if-conditions.md)
- [Color scale & data bars](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/color-scale.md)
- [Classification](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/classification.md): Learn how to use classification-based conditional formatting - such as text, icons, and ratings - to quickly gain insights from your reports.
- [Ranking](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/ranking.md): Plan highlights the top or bottom N ranked values, making it easy to quickly identify the highest- and lowest-performing items.
- [Field Value](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/field-value.md): Learn how to use field value–based conditional formatting to dynamically format your Microsoft Fabric reports using Plan.
- [Bubble Charts](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/bubble-charts.md): In this section, we'll look at bubble charts. Note that you can either create a new rule as shown here or edit the bubble charts inserted using the one-click option explained here.
- [Action Dots](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/action-dots.md): Learn how to use Action Dots to visually represent performance for faster, more efficient analysis in Plan.
- [Manage rules](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/manage-rules.md)
- [Planning, Budgeting & Forecasting](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting.md)
- [What-if Analysis & Simulations](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/what-if-analysis-and-simulations.md)
- [Scenario](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario.md)
- [Compare Scenarios](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario/compare-scenarios.md)
- [Goal Seek](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/goal-seek.md)
- [Budgeting & Allocations](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/budgeting-and-allocations.md)
- [Allocation Rules and Controls](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls.md)
- [Locking Rule](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/locking-rule.md)
- [Distribution rules](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/distribution-rules.md)
- [Min-Max Rule](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/min-max-rule.md)
- [Column aggregation](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/column-aggregation.md)
- [Commenting and Collaboration](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration.md): Collaborate seamlessly with comments and notes
- [Notes](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/notes.md): Annotate data with notes to add descriptive context
- [Comments](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments.md): Discuss data, assign tasks, and track changes using comments
- [Data-level comments](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comments.md): Comment on data and collaborate using mentions and replies
- [Assign tasks & monitor progress](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comments-1.md): Assign comments as tasks and track their status across stakeholders
- [Filter & track changes](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/track-changes.md): Filter and track comment activity across the report
- [Report-level comments](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/report-level-comments.md): Leverage report-level comments to collaborate, assign tasks, and provide an overall summary of the report
- [Comment settings](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comment-settings.md): Configure comment settings to control access, thread behavior, and notifications
- [Exporting reports](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports.md)
- [Export to PDF & Excel](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports/export.md)
- [Export to Excel](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports/export/export-to-excel.md)
- [Export to PDF](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports/export/export-to-pdf.md)
- [Snapshot](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports/snapshot-writeback-matrix-only.md)
- [Comparing snapshots](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/10.-exporting-reports/snapshot-writeback-matrix-only/comparing-snapshots.md)
- [Driver Model](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/model-builder.md)
- [Configure row properties in the model](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/configure-row-properties-in-the-model.md)
- [Create a model using Model Builder](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-a-model-using-model-builder.md)
- [Create templates for reusable row structures](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-templates-for-reusable-row-structures.md)
- [Create a driver-based model](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/create-a-driver-based-model.md)
- [Tree view](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/tree-view.md)
- [Visualize the model using the tree layout](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/visualize-the-model-using-the-tree-layout.md)
- [Optimize input values to meet a target](https://docs.fabricplan.com/documentation/readme/planning-sheets/how-tos/optimize-input-values-to-meet-a-target.md)
- [Formula syntax](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax.md)
- [Conditional statements](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements.md)
- [IF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/if-1.md)
- [IFNA](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/ifna.md)
- [AVERAGEIF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/if.md)
- [COUNTIF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/countif.md)
- [SUMIF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/sumif.md)
- [FILTERIF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/filterif.md)
- [SWITCH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/conditional-statements/switch.md)
- [Logical functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions.md)
- [AND](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/and.md)
- [OR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/or.md): Evaluates multiple conditions and returns TRUE if at least one condition is satisfied.
- [NOT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/not.md): Reverses a logical result and returns the opposite boolean value
- [XOR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/xor.md): Evaluates multiple conditions and returns TRUE only if exactly one or an odd number of conditions are met.
- [IN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/in.md): Checks if a value matches the values within a given list or array of values and returns TRUE if it matches.
- [ISBLANK](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/isblank.md): Checks whether a cell is blank and returns TRUE or FALSE.
- [ISNUMBER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/isnumber.md): Checks whether a cell value is a valid number and returns TRUE or FALSE.
- [ISREFEXIST](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/logical-functions/isrefexist.md): Verifies whether a reference exists and returns a logical result.
- [Math functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions.md)
- [ABS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/abs.md)
- [AVERAGE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/average.md)
- [AVERAGEEXNEG](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/averageexneg.md)
- [AVERAGEEXZERO](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/averageexzero.md)
- [AVERAGEEXZERONEG](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/averageexzeroneg.md)
- [CEILING](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/ceiling.md)
- [COUNT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/count.md)
- [DIVIDE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/divide.md)
- [EVEN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/even.md)
- [EXP](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/exp.md)
- [ODD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/odd.md)
- [FLOOR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/floor.md)
- [INDEXOF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/indexof.md)
- [LARGE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/large.md)
- [LOG](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/log.md)
- [MAX](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/max.md)
- [MIN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/min.md)
- [MOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/mod.md)
- [MROUND](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/mround.md)
- [NUMBERVALUE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/numbervalue.md)
- [PCT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/pct.md)
- [POWER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/power.md)
- [PRODUCT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/product.md)
- [RAND](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/rand.md)
- [RANDBETWEEN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/randbetween.md)
- [ROUND](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/round.md)
- [ROUNDDOWN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/rounddown.md)
- [ROUNDUP](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/roundup.md)
- [SORT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/sort.md)
- [SUBTRACT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/subtract.md)
- [SUM](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/sum.md)
- [SMALL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/small.md)
- [SQRT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/sqrt.md)
- [PMT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/math-functions/pmt.md)
- [Text formatting functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions.md)
- [CONCATENATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/concatenate.md): Joins multiple text strings into one single combined text value.
- [CONCATALL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/concatall.md)
- [HYPERLINK](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/hyperlink.md)
- [LEFT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/left.md)
- [LOWER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/lower.md)
- [MID](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/mid.md)
- [PROPER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/proper.md)
- [REPLACE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/replace.md)
- [REPT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/rept.md)
- [RIGHT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/right.md)
- [TEXT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/text.md)
- [TRIM](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/trim.md)
- [UPPER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/upper.md): Converts text to uppercase letters.
- [VALUE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/value.md)
- [LEN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/text-formatting-functions/len.md): Returns the number of characters in a text string, including spaces and special characters.
- [Date functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions.md): Date functions allow you to create, format, extract, calculate, and manipulate date and time values.
- [DATEADD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/dateadd.md)
- [DATEDIFF](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/datediff.md)
- [DAY](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/day.md)
- [DATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/date.md)
- [DATE.FORMAT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/date.format.md)
- [SOWEEK](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/soweek.md)
- [SOMONTH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/somonth.md)
- [SOQTR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/soqtr.md)
- [SOYEAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/soyear.md)
- [EOWEEK](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/eoweek.md)
- [EOMONTH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/eomonth.md)
- [EOQTR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/eoqtr.md)
- [EOYEAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/eoyear.md)
- [NETWORKDAYS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/networkdays.md)
- [ADDDAYS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/adddays.md)
- [ADDWEEKS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/addweeks.md)
- [ADDMONTHS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/addmonths.md)
- [ADDQTRS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/addqtrs.md)
- [ADDYEARS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/addyears.md)
- [FROM\_EXCELDATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/fromexceldate.md)
- [MONTH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/month.md)
- [DATE.NOW](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/now.md)
- [PERIOD\_RANGE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/period_range.md)
- [TO\_EXCELDATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/toexceldate.md)
- [YEAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/date-functions/year.md)
- [Time intelligence functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions.md)
- [AGGREGATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/aggregate.md)
- [FILTER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/filter.md)
- [COLUMN\_PERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/column_period.md)
- [LASTNDAY](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/lastnday.md)
- [LASTNMONTH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/lastnmonth.md)
- [LASTNQTR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/lastnqtr.md)
- [LASTNYEAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/lastnyear.md)
- [MONTHPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/monthperiod.md)
- [MOVINGAVERAGE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/movingaverage.md)
- [MOVINGSUM](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/movingsum.md)
- [MTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/mtd.md)
- [NEXTNDAY](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/nextnday.md)
- [NEXTNMONTH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/nextnmonth.md)
- [NEXTNQTR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/nextnqtr.md)
- [NEXTNYEAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/nextnyear.md)
- [QTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/qtd.md)
- [QTRPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/qtrperiod.md)
- [SHIFT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/shift.md)
- [TOTALYTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/totalytd.md)
- [TOTALQTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/totalqtd.md)
- [TOTALMTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/totalmtd.md)
- [VALUEAT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/valueat.md)
- [YEARPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/yearperiod.md)
- [YTD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/time-intelligence-functions/ytd.md)
- [Other operators](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/other-operators.md)
- [Identifiers](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers.md)
- [CLOSEDPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/closedperiod.md)
- [COLUMN.DATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/column.date.md)
- [COLUMN.PARENT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/column.parent.md)
- [COLUMNS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/column.md)
- [CURRENT\_PERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/current_period.md)
- [DESCENDANTS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/descendants.md)
- [FORECAST.CLOSED\_END](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/forecast.closed_end.md)
- [FORECAST.CLOSED\_START](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/forecast.closed_start.md)
- [FORECAST.OPEN\_END](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/forecast.open_end.md)
- [FORECAST.OPEN\_START](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/forecast.open_start.md)
- [GROUP INDEX](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/group-index.md)
- [HAS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/has.md)
- [HAS\_ALL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/has_all.md)
- [HAS\_SOME](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/has_some.md)
- [LEAVES](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/leaves.md)
- [LEVEL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/level.md)
- [LOGGEDIN\_EMAIL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/loggedin_email.md)
- [LOGGEDIN\_NAME](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/loggedin_name.md)
- [MATCH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/match.md)
- [MAXDATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/maxdate.md)
- [MEMBERS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/members.md)
- [MINDATE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/mindate.md)
- [RELATIVE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/relative.md)
- [RELATIVE\_COLUMN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/relative_column.md)
- [ROW.PARENT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/row.parent.md)
- [ROW.LABEL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/identifiers/row.label.md)
- [Scripting functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions.md)
- [DISPLAYTOAST](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/displaytoast.md)
- [EXPORT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/export.md)
- [LAYOUT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/layout.md)
- [OPENFILTER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/openfilter.md)
- [OPENKPIEXPLORER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/openkpiexplorer.md)
- [OPENMANAGECOLUMN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/openmanagecolumn.md)
- [OPENSEARCH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/opensearch.md)
- [OPENTOPN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/opentopn.md)
- [SENDMAIL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/sendmail.md)
- [SETCFRULE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setcfrule.md)
- [SETCOLUMNSORT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setcolumnsort.md)
- [SETFILTER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setfilter.md)
- [SETFILTERBYINDEX](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setfilterbyindex.md)
- [SETFONTSIZE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setfontsize.md)
- [SETFOOTER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setfooter.md)
- [SETHEADER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setheader.md)
- [SETLOCK](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setlock.md)
- [SETMEASURETITLE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setmeasuretitle.md)
- [SETMAXDECIMALPRECISION](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setmaxdecimalprecision.md)
- [SETPAGINATION](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setpagination.md)
- [SETSCALING](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setscaling.md)
- [SETSEMANTICFORMATTING](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setsemanticformatting.md)
- [SETSTATUSBAR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setstatusbar.md)
- [SETVALUE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setvalue.md)
- [SETVISIBILITY](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/setvisibility.md)
- [SHOWBETWEENPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/showbetweenperiod.md)
- [SHOWCLOSEDFORECAST](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/showclosedforecast.md)
- [SHOWMEASUREBETWEENPERIOD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/showmeasurebetweenperiod.md)
- [TOPN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/topn.md)
- [DISPLAY SETTINGS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings.md)
- [SETBLANKLABEL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/setblanklabel.md)
- [SETSUPPRESSZEROS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/setsuppresszeros.md)
- [SETRAGGEDHIERARCHY](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/setraggedhierarchy.md)
- [SEPARATOR](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/separator.md)
- [SETCOMBINECOLUMNHEADER](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader.md)
- [SEMANTICFORMAT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/semanticformat.md)
- [SHOWNULLAS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/shownullas.md)
- [SHOWZEROAS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/showzeroas.md)
- [SINGLECHILD](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/scripting-functions/display-settings/singlechild.md)
- [Statistical Functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions.md): Analyze data using statistical functions to summarize, measure variation, and uncover insights.
- [MEDIAN](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/median.md): Determines the central value in a dataset.
- [MODE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/mode.md): Returns the value with the highest frequency in a dataset.
- [MODESNGL](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/modesngl.md): Returns the single most frequently occurring value in a dataset. When multiple numbers appear frequently, it returns the first mode.
- [RANKEQ](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/rankeq.md): Returns the position of a number in a list. Newer version of RANK.
- [RANKAVG](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/rankavg.md): Returns the position of a number in a list. If there are duplicates, this function gives them the average rank.
- [QUARTILEINC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/quartileinc.md): Calculate quartiles using the inclusive method to understand data distribution.
- [QUARTILEEXC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/quartileexc.md): Calculate quartiles using the exclusive method to understand data distribution.
- [VARS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/vars.md): Calculates the sample variance of a dataset to measure how widely values are spread from the mean.
- [VARP](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/varp.md): Calculates the population variance of a dataset to measure how widely values are spread from the mean.
- [STDEVS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/stdevs.md): Measures the sample standard deviation to analyze data variability.
- [STDEVP](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/stdevp.md): Measures the population standard deviation to analyze data variability.
- [PERCENTILEINC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/percentileinc.md): Calculates the percentile of a dataset to find the value below which a given percentage of data falls.
- [PERCENTILEEXC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/percentileexc.md): Calculates the exclusive percentile of a dataset to find the value below which a given percentage of data falls.
- [NORMDIST](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/normdist.md): Calculates the normal distribution probability for a specific value based on a given mean and standard deviation.
- [NORMSDIST](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/normsdist.md): Calculates the standard normal distribution probability for a specific value to analyze data variability on a standardized scale.
- [NORMINV](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/norminv.md): Calculates the inverse normal distribution for a specific probability to determine the corresponding value based on a given mean and standard deviation.
- [NORMSINV](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/normsinv.md): Calculates the inverse of the standard normal cumulative distribution to find the z-score for a given probability with a mean of 0 and a standard deviation of 1.
- [PERCENTRANKINC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/percentrank.inc.md): Calculates the inclusive percentage rank of a value within a dataset to determine its relative position among other values.
- [PERCENTRANKEXC](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/statistical-functions/percentrankexc.md): Calculates the exclusive percentage rank of a value within a dataset to determine its relative position among other values.
- [Miscellaneous functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/miscellaneous-functions.md)
- [FETCH](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/miscellaneous-functions/fetch.md)
- [LOOKUP](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/miscellaneous-functions/lookup.md)
- [Measure/Column selection functions](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/measure-column-selection-functions.md)
- [GETCOLBETWEENPERIODS](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/measure-column-selection-functions/getcolbetweenperiods.md)
- [GETMEASURE](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/measure-column-selection-functions/getmeasure.md)
- [SELECT](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/measure-column-selection-functions/select.md)
- [SELECT\_BYINDEX](https://docs.fabricplan.com/documentation/readme/planning-sheets/formula-syntax/measure-column-selection-functions/select_byindex.md)
- [Backup & restore report config](https://docs.fabricplan.com/documentation/readme/planning-sheets/export-and-import-reports-backup.md)
- [Troubleshoot](https://docs.fabricplan.com/documentation/readme/planning-sheets/troubleshoot.md)
- [PowerTable sheets](https://docs.fabricplan.com/documentation/readme/powertable-sheets.md)
- [Concepts](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts.md)
- [Relation column (Master-detail relationship)](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts/master-detail-tables-parent-child-linked-records.md)
- [Layouts](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts/layouts.md)
- [Gantt chart](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts/gantt-chart.md)
- [Slowly changing dimensions](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts/type-2-scds.md)
- [Automation](https://docs.fabricplan.com/documentation/readme/powertable-sheets/concepts/automation.md)
- [How-tos](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos.md)
- [Build a no-code table app with PowerTable](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets.md)
- [Connect PowerTable sheet to a semantic model](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/connect-powertable-sheet-to-a-semantic-model.md)
- [Connect to a Database](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/connect-to-a-database.md)
- [Enter Data Manually](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/enter-data-manually.md)
- [Data management](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/basic-table-operations.md)
- [Edit and Bulk-edit data](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/basic-table-operations/edit-and-bulk-edit-data.md)
- [Preview Changes](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/basic-table-operations/preview-changes.md)
- [Insert, import, duplicate, and delete rows](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/insert-import-duplicate-and-delete-rows.md)
- [Add Columns - Overview](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview.md)
- [Add visual column overview](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column.md)
- [Multi-select relationship column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column.md)
- [Reference Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column.md)
- [Relation Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/relation-column.md)
- [Rollup column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column.md)
- [Button Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/button-column.md)
- [Attachment Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/attachments-column.md)
- [Add Database Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-database-column.md)
- [Add Formula Column](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-formula-column.md)
- [Configure column properties](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/configure-column-properties.md)
- [General](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/configure-column-properties/general.md)
- [Display](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/configure-column-properties/display.md)
- [Lookup and relation](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/configure-column-properties/lookup-and-relation.md)
- [Set up row and column access control](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/set-up-row-and-column-access-control.md)
- [Manage Columns](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/manage-columns.md)
- [Change column widths](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/manage-columns/change-column-widths.md)
- [Configure layouts](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary.md)
- [Hierarchy](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/hierarchy-layout.md)
- [Crosstab](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/crosstab.md)
- [Gantt](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/gantt-chart-view.md)
- [Resource](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/resource-view.md)
- [Calendar](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/calendar.md)
- [Kanban](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/layout-views-summary/kanban.md)
- [Create data entry forms](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/generate-forms.md)
- [Approval flow](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/approval-flow.md)
- [Configure approval workflow](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/approval-flow/configure-approval-workflow.md)
- [Review changes in PowerTable approval workflow](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/approval-flow/review-changes-in-powertable-approval-workflow.md)
- [Create automation](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/create-automation.md)
- [Collaborative Commenting](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/collaborative-commenting.md)
- [View all comments & track changes](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/collaborative-commenting/view-all-comments-and-track-changes.md)
- [Assign users & task status](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/collaborative-commenting/assign-users-and-task-status.md)
- [Comment Settings](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/collaborative-commenting/comment-settings.md)
- [Export powertable sheet](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/export-powertable-sheet.md)
- [Conditional Formatting](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/conditional-formatting.md)
- [Audit log](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/audit-log.md)
- [Create slowly changing dimensions](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/create-slowly-changing-dimensions.md)
- [Reference](https://docs.fabricplan.com/documentation/readme/powertable-sheets/reference.md)
- [Supported column types](https://docs.fabricplan.com/documentation/readme/powertable-sheets/reference/supported-column-types.md)
- [Supported file types for attachment](https://docs.fabricplan.com/documentation/readme/powertable-sheets/reference/supported-file-types-for-attachment.md)
- [Intelligence sheets](https://docs.fabricplan.com/documentation/readme/intelligence-sheets.md)
- [How-tos](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos.md)
- [Get started with Intelligence sheets](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/get-started-with-intelligence-sheets.md)
- [Apply conditional formatting](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/apply-conditional-formatting.md)
- [Showcase data points in charts](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/apply-conditional-formatting/showcase-data-points-in-charts.md)
- [Highlight tabular data with conditional formatting](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/apply-conditional-formatting/highlight-tabular-data-with-conditional-formatting.md)
- [Create rules](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/apply-conditional-formatting/create-rules.md)
- [Build financial reports](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/build-financial-reports.md)
- [Collaborate on reports with comments](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/collaborate-on-reports-with-comments.md)
- [Pagination and formatting for Reports](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/pagination-and-formatting-for-reports.md)
- [Export high-quality PDF & Excel reports](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/export-high-quality-pdf-and-excel-reports.md)
- [Visualize simulations, budgets, and forecasts](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts.md)
- [Plan projects with Gantt charts](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/plan-projects-with-gantt-charts.md)
- [Retain report data with Writeback](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/retain-report-data-with-writeback.md)
- [Build multi-measure charts](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/build-multi-measure-charts.md)
- [Use themes for consistent color schemes](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/use-themes-for-consistent-color-schemes.md)
- [Ranking data](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/ranking-data.md)
- [Sorting data](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/how-tos/sorting-data.md)
- [Compare data with small multiples](https://docs.fabricplan.com/documentation/readme/intelligence-sheets/compare-data-with-small-multiples.md)
- [Infobridge](https://docs.fabricplan.com/documentation/readme/infobridge.md)
- [How-tos](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos.md)
- [Create a bridge to integrate and transform plans](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/1.-create-bridge.md)
- [Consolidate data between sheets](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/import-measures-between-planning-sheets.md)
- [Import data into a bridge](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/2.-add-source-to-bridge.md)
- [Manage query operations](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/4.-manage-queries.md)
- [Query transformations](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/query-transformations.md)
- [Append](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/query-transformations/append.md): In the module, we'll explore how to use append functions to combine data with the same structure from multiple tables.
- [Join](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/query-transformations/join.md): Explore how to leverage joins to retrieve data from multiple tables using a related column.
- [Duplicate](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/query-transformations/duplicate.md)
- [Writeback transformed data from InfoBridge](https://docs.fabricplan.com/documentation/readme/infobridge/how-tos/writeback-transformed-data-from-infobridge.md)
- [4. Manage sources](https://docs.fabricplan.com/documentation/readme/infobridge/4.-manage-sources.md)
- [6. Insert measure from bridge](https://docs.fabricplan.com/documentation/readme/infobridge/6.-insert-measure-from-bridge.md)
- [7. Manage Integration of Plan items](https://docs.fabricplan.com/documentation/readme/infobridge/7.-manage-integration-of-visuals.md)
- [8. Manage Bridges](https://docs.fabricplan.com/documentation/readme/infobridge/8.-manage-bridges.md)
- [9. Data transformations](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations.md)
- [Pivot table](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/pivot-table.md)
- [Group by](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/group-by.md): Learn how to aggregate and summarize detailed reports with the Group by transformation.
- [Add Column](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/add-column.md)
- [Pivot column](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/pivot-column.md)
- [Rename column](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/rename-column.md)
- [Find and Replace](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/find-and-replace.md)
- [Remove measure](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/remove-measure.md)
- [Filter rows](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/filter-rows.md)
- [Sort](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/sort.md)
- [Text functions](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/text-functions.md)
- [Unnest](https://docs.fabricplan.com/documentation/readme/infobridge/9.-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/documentation/readme/infobridge/9.-data-transformations/round.md)
- [Extract Comments](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/extract-comments.md)
- [Import and export](https://docs.fabricplan.com/documentation/readme/infobridge/9.-data-transformations/import-and-export.md)
- [10. Integrating forecasts](https://docs.fabricplan.com/documentation/readme/infobridge/10.-integrating-forecasts.md)
- [11. Collaborative adjustments](https://docs.fabricplan.com/documentation/readme/infobridge/11.-collaborative-adjustments.md)
- [Infobridge sheets in Plan (preview)](https://docs.fabricplan.com/documentation/readme/infobridge/infobridge-sheets-in-plan-preview.md)
- [Disaster recovery guidance](https://docs.fabricplan.com/documentation/readme/disaster-recovery-guidance.md): Experience-Specific Recovery Procedures for Planning in Fabric IQ


---

# 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:

```
GET https://docs.fabricplan.com/documentation.md?ask=<question>
```

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.