{"version":1,"pages":[{"id":"wrJjhh6HimasChVFwsji","title":"What is Plan?","pathname":"/","siteSpaceId":"sitesp_ofx2Z","icon":"solar-system","description":"No-code, Full-stack Planning + BI + Data Management Suite on Microsoft Fabric"},{"id":"yhoI2pskOHnFzCj1xx8z","title":"Row-level security (RLS) behavior in  Plan","pathname":"/readme/row-level-security-rls-behavior-in-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"What is Plan?","icon":"solar-system"}]},{"id":"xunEw97oaOkyBKj7GBrm","title":"Prerequisites for Plan","pathname":"/readme/prerequisites-for-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"What is Plan?","icon":"solar-system"}]},{"id":"uz01O120wTPdTlm5Wt1x","title":"Known issues and limitations","pathname":"/readme/known-issues-and-limitations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"What is Plan?","icon":"solar-system"}]},{"id":"zOhzSeRQbAUSwDMtArUH","title":"Roles in Fabric Plan","pathname":"/readme/roles-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"What is Plan?","icon":"solar-system"}]},{"id":"7gNlKsdJkA79xdb2VL3T","title":"Role upgrades","pathname":"/readme/roles-in-fabric-plan/role-upgrades","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"What is Plan?","icon":"solar-system"},{"label":"Roles in Fabric Plan"}]},{"id":"ugICQJZi6XrRJhspZBOt","title":"Planning sheets","pathname":"/planning-sheets","siteSpaceId":"sitesp_ofx2Z","icon":"table-cells-header-unlock"},{"id":"hQuoBmOCAhyVsgMsvmLC","title":"How-tos","pathname":"/planning-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"}]},{"id":"cdI66wSzhRixH7PvQYSJ","title":"Create and share a cloud connection for a semantic model","pathname":"/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"32udHuAAnrjaoP9YGb2K","title":"Creating a Planning Sheet","pathname":"/planning-sheets/how-tos/creating-a-planning-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hjgalITOm5gNjp3btmJ7","title":"Create a database connection for collaboration","pathname":"/planning-sheets/how-tos/create-a-database-connection-for-collaboration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"C3eNamsIHNBzkFaH2sS6","title":"Forecast data to predict future trends","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"56ZdqBvao2mImGLgoziF","title":"Create multi-dimensional forecasts","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"Q99ASWXN01SpgGbXXIZY","title":"Manage rolling forecasts","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"enG17VIVLgDrBqarBz2x","title":"Generate forecasts from statistical data","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"JmRtfblb2NGqw4WYPcpz","title":"Extend planning beyond source data periods","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"lVABeURDpuO7AZw9OsMR","title":"Edit forecast settings","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"CV1J3gR5V3v6mzIGwhey","title":"Allocate deficits to meet targets","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"reUhWMJReoPJx3nMOebV","title":"Commenting and collaboration","pathname":"/planning-sheets/how-tos/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"nao19jxgUlvWKmZe4Dws","title":"Notes in Commenting and Collaboration","pathname":"/planning-sheets/how-tos/commenting-and-collaboration/notes-in-commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Commenting and collaboration"}]},{"id":"5NujCR2SrMNR09b0W5R5","title":"Extend Planning sheet with data input","pathname":"/planning-sheets/how-tos/extend-planning-sheet-with-data-input","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ojfVbC8weTCSyrmD2svw","title":"Plan across multiple dimensions with cubes","pathname":"/planning-sheets/how-tos/allocate-values-across-dimensions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"1n70ugrLLDOPJM1ttzWl","title":"Analyze planning outcomes with scenarios","pathname":"/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"StOkLWFlLNX7jrBGKH9m","title":"Bookmarks","pathname":"/planning-sheets/how-tos/bookmarks","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ogdxreRx6iCfHv6dV18I","title":"Exports in the Planning sheet","pathname":"/planning-sheets/how-tos/exports-in-the-planning-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ljF8Vd8hRu34ByjfZDHt","title":"Pivot","pathname":"/planning-sheets/how-tos/pivot","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"wkUDlmQTLrz6mBXv8FNM","title":"Layouts","pathname":"/planning-sheets/how-tos/layouts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"NJKIjeK5xkYfXFeJnoCI","title":"Conditional formatting","pathname":"/planning-sheets/how-tos/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"blr1sXqrk99n458u3l7r","title":"Create rules in Conditional Formatting","pathname":"/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"TLJLKSaQ412kvGUi6tUJ","title":"Format by Rules (If conditions) in conditional formatting","pathname":"/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"ysKUmvvAM1A7PE1MDoKF","title":"Format by Color scale conditional formatting","pathname":"/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"QRxTHh7Xydnk9EGS7hhb","title":"Format by classification conditional formatting","pathname":"/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"luE2mAltuHVcCvqalzIa","title":"Quick formatting options","pathname":"/planning-sheets/how-tos/conditional-formatting/quick-formatting-options","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"4VWIF6r8UVi3Fr8WETny","title":"Manage Rules","pathname":"/planning-sheets/how-tos/conditional-formatting/manage-rules","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"FjnLgf3NSz36MS9nYheM","title":"Persist data with Writeback","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"LBWy9L9l6V46sFmatyuV","title":"Writeback in Plan","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/writeback-in-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"ZBLm8CHg8M8z77AiVqqz","title":"General Settings","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/general-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"KdigUkMbNEWZ0ON80azs","title":"Data Settings","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/data-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"Zwuzsh1Id7CpkQ4dHAtx","title":"Destination Settings","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/destination-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"5kLqldRHvClIYmRWO6C4","title":"Configure advanced settings","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"LECa1REKl1ZFEcFdLvXo","title":"Configure writeback destinations","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-writeback-destinations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"4SdrxPiQ52gYjlEteuU7","title":"View Logs","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/view-logs","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"UARhSdHLBI4rGMK6Ake1","title":"Enable writeback in reading mode","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/enable-writeback-in-reading-mode","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"7qlFuQ6aPHy2URrEJuWh","title":"FAQs on Writeback","pathname":"/planning-sheets/how-tos/persist-planning-data-using-writeback/faqs-on-writeback","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"2IGnqW2o1Vcnn3kSWp2I","title":"Basic formatting","pathname":"/planning-sheets/how-tos/basic-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"EyGNjzwqnB1ukDRJfEyq","title":"Number formatting","pathname":"/planning-sheets/how-tos/basic-formatting/number-formatting","siteSpaceId":"sitesp_ofx2Z","description":"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.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"DdORdsuq4X3JclMGYIdo","title":"Cell, header & value formatting","pathname":"/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"lSwDqdFQXNVTpL2udjqI","title":"Total and Subtotals","pathname":"/planning-sheets/how-tos/basic-formatting/total-and-subtotals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"IyCVP7zLYoBmUuowRyDd","title":"Adding business logic and formulas","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"OMtmpKnMz1GVW7YLaILZ","title":"Edit cells","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"uZWWkdI8Mv8u79Zim6Bo","title":"Rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"jSIgD4V7zFEb7piAT7XT","title":"Insert data input rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"scV8vUppjZTho20bqdmC","title":"Insert template rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/template-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"LKop9ZyaVJubQf3gshCj","title":"Insert formula rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"gxazJQpGQs6lmYyUO1WW","title":"Insert blank rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-blank-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"AIvCvRvyYsV4oY5sGC4H","title":"Insert forecast rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"pchxDbba98RbD3fElSgm","title":"Measures and Columns","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"lJKvzuF7vHqgAxSIHXkl","title":"Insert data input columns","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"}]},{"id":"d1U162wTDoFssKWgWuRI","title":"Number","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"},{"label":"Insert data input columns"}]},{"id":"3nvoF8bszv5lxkBK5ZEC","title":"Dropdown","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"},{"label":"Insert data input columns"}]},{"id":"m6YJeyIaNQ1IDxqgRFYV","title":"Text, checkbox & date","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/text-checkbox-and-date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"},{"label":"Insert data input columns"}]},{"id":"gsseNJII7Ejev5TjHEvc","title":"Person","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/writeback-matrix-features","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"},{"label":"Insert data input columns"}]},{"id":"1QRk9xoEQXY361kN9gIV","title":"Insert Formula columns","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-calculated-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"}]},{"id":"ZcrSbaWuo8gTHQBXoVvZ","title":"Manage inserted rows","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"RAEFEzKcwtq8fnuE5khV","title":"Manage inserted measures & columns","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns-1","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"UGa4ygn5Q0KwCMzGGz6G","title":"Manage aggregation","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation","siteSpaceId":"sitesp_ofx2Z","description":"Custom Measure Aggregations in Semantic Models with Plan","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"SD9pAFc5pPpTQoR77RwI","title":"Row aggregation","pathname":"/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation/row-aggregation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Manage aggregation"}]},{"id":"DWI49p81aMdK9riMNwzA","title":"Planning, Budgeting & Forecasting","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"7C6BngujIfZWpOQ00bnl","title":"What-if Analysis & Simulations","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/what-if-analysis-and-simulations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"}]},{"id":"b3j3M0aWu2vmgXeiq4zB","title":"Goal Seek","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/goal-seek","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"}]},{"id":"TSNS85SdH8B2eu0qCf2y","title":"Budgeting & Allocations","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/budgeting-and-allocations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"}]},{"id":"7gdiHwZQ3pgtoXisTtUY","title":"Allocation Rules and Controls","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"}]},{"id":"nncoUUS2sKNgxqKJztDN","title":"Locking Rule","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/locking-rule","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"},{"label":"Allocation Rules and Controls"}]},{"id":"iMvcEkPsVncSj1icFrDb","title":"Distribution rules","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/distribution-rules","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"},{"label":"Allocation Rules and Controls"}]},{"id":"Ju9ezrAImaVxt9eiSfKZ","title":"Column aggregation","pathname":"/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/column-aggregation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Planning, Budgeting & Forecasting"}]},{"id":"lCg9K2VWet47fjVESeVN","title":"Driver Model","pathname":"/planning-sheets/how-tos/driver-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"xfiMOgyqnLoMBuvoTxlN","title":"Configure row properties in the model","pathname":"/planning-sheets/how-tos/configure-row-properties-in-the-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"d6rs7TRO1z2GvfBoZB1L","title":"Create a model using Model Builder","pathname":"/planning-sheets/how-tos/create-a-model-using-model-builder","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0ODTeMsLrVn037bb0q6D","title":"Create templates for reusable row structures","pathname":"/planning-sheets/how-tos/create-templates-for-reusable-row-structures","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"7Az90ELevX5Pj7yxkMOs","title":"Create a driver-based model","pathname":"/planning-sheets/how-tos/create-a-driver-based-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Q1HWbQ9Q5w1WySW0P4Gd","title":"Tree view","pathname":"/planning-sheets/how-tos/tree-view","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZVYVHUlpNUDkd5L33BKQ","title":"Visualize the model using the tree layout","pathname":"/planning-sheets/how-tos/visualize-the-model-using-the-tree-layout","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"U0FBYMlrBSZ8qQf7i6Vp","title":"Optimize input values to meet a target","pathname":"/planning-sheets/how-tos/optimize-input-values-to-meet-a-target","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZFTFsgwv0bRdrLoSHcmC","title":"Formula syntax","pathname":"/planning-sheets/formula-syntax","siteSpaceId":"sitesp_ofx2Z","icon":"function","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"}]},{"id":"sa4NQI7P13MQxpK5GuRE","title":"Conditional statements","pathname":"/planning-sheets/formula-syntax/conditional-statements","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"6ncprsZrxfdDkhQqJjzD","title":"IF","pathname":"/planning-sheets/formula-syntax/conditional-statements/if-1","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"kpV70s7pDTMSFZYVw42Y","title":"IFNA","pathname":"/planning-sheets/formula-syntax/conditional-statements/ifna","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"OmwDdnAK2dkOY0S3FhYJ","title":"AVERAGEIF","pathname":"/planning-sheets/formula-syntax/conditional-statements/if","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"iECGUFe2ReeJVSry1GSt","title":"COUNTIF","pathname":"/planning-sheets/formula-syntax/conditional-statements/countif","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"XIeCjaoVGMXYSBB69OuQ","title":"SUMIF","pathname":"/planning-sheets/formula-syntax/conditional-statements/sumif","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"I7lPfAjhtweIMLU9AgMU","title":"FILTERIF","pathname":"/planning-sheets/formula-syntax/conditional-statements/filterif","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"lpQusNFc5ikkcgPkPBGv","title":"SWITCH","pathname":"/planning-sheets/formula-syntax/conditional-statements/switch","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"nszR6GLXPDZRYJlf8uo1","title":"Logical functions","pathname":"/planning-sheets/formula-syntax/logical-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"P6N0doSC1PFoNpCmBvEn","title":"AND","pathname":"/planning-sheets/formula-syntax/logical-functions/and","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"bxrdTCnz4iqwTAxkLNzT","title":"OR","pathname":"/planning-sheets/formula-syntax/logical-functions/or","siteSpaceId":"sitesp_ofx2Z","description":"Evaluates multiple conditions and returns TRUE if at least one condition is satisfied.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"Yo9eM1NYF4GmTQJzZtKk","title":"NOT","pathname":"/planning-sheets/formula-syntax/logical-functions/not","siteSpaceId":"sitesp_ofx2Z","description":"Reverses a logical result and returns the opposite boolean value","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"atCcWniv5j24vVzCjKsu","title":"XOR","pathname":"/planning-sheets/formula-syntax/logical-functions/xor","siteSpaceId":"sitesp_ofx2Z","description":"Evaluates multiple conditions and returns TRUE only if exactly one or an odd number of conditions are met.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"hnfkKtUDry7uYYkqSbMN","title":"IN","pathname":"/planning-sheets/formula-syntax/logical-functions/in","siteSpaceId":"sitesp_ofx2Z","description":"Checks if a value matches the values within a given list or array of values and returns TRUE if it matches.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"xwYXz9yPz1Y6m1fpK2LH","title":"ISBLANK","pathname":"/planning-sheets/formula-syntax/logical-functions/isblank","siteSpaceId":"sitesp_ofx2Z","description":"Checks whether a cell is blank and returns TRUE or FALSE.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"kxKdlOJYXGJvrGISXVzk","title":"ISNUMBER","pathname":"/planning-sheets/formula-syntax/logical-functions/isnumber","siteSpaceId":"sitesp_ofx2Z","description":"Checks whether a cell value is a valid number and returns TRUE or FALSE.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"q3VkPQYAADLjTYE1oNIe","title":"ISREFEXIST","pathname":"/planning-sheets/formula-syntax/logical-functions/isrefexist","siteSpaceId":"sitesp_ofx2Z","description":"Verifies whether a reference exists and returns a logical result.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"Y712qvACJKscliWpkgIR","title":"Math functions","pathname":"/planning-sheets/formula-syntax/math-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"UsCxpkfhBIeCpvlqnWNx","title":"ABS","pathname":"/planning-sheets/formula-syntax/math-functions/abs","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"JBoRRVj5qT9rdqIsWmtw","title":"AVERAGE","pathname":"/planning-sheets/formula-syntax/math-functions/average","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"NEn6c0ucJMJS3HRphoBE","title":"AVERAGEEXNEG","pathname":"/planning-sheets/formula-syntax/math-functions/averageexneg","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BadHKyTHhL5Jow3IfqDe","title":"AVERAGEEXZERO","pathname":"/planning-sheets/formula-syntax/math-functions/averageexzero","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3272xD4VM7ZllCoffQFK","title":"AVERAGEEXZERONEG","pathname":"/planning-sheets/formula-syntax/math-functions/averageexzeroneg","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vEPEvcXwCO46Tdsva8MD","title":"CEILING","pathname":"/planning-sheets/formula-syntax/math-functions/ceiling","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Yz1XlakVaVicTypHYc3w","title":"COUNT","pathname":"/planning-sheets/formula-syntax/math-functions/count","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"qxOMGC31bXZW9HrCyx8q","title":"DIVIDE","pathname":"/planning-sheets/formula-syntax/math-functions/divide","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"QKvQ7PxOJVtutBvts03M","title":"EVEN","pathname":"/planning-sheets/formula-syntax/math-functions/even","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"emWtv4FFTn04pXfhw6DX","title":"EXP","pathname":"/planning-sheets/formula-syntax/math-functions/exp","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"gF0dt7epJsFddE5eH4uz","title":"ODD","pathname":"/planning-sheets/formula-syntax/math-functions/odd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"m0JQYMdN9r3n5IyAT1dD","title":"FLOOR","pathname":"/planning-sheets/formula-syntax/math-functions/floor","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"WqBOIHuaEwVDQqdaauFH","title":"INDEXOF","pathname":"/planning-sheets/formula-syntax/math-functions/indexof","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Z4U3PCqjuI5n6wBj6ubh","title":"LARGE","pathname":"/planning-sheets/formula-syntax/math-functions/large","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Wr4yqb6iXLHD5zRNRU0l","title":"LOG","pathname":"/planning-sheets/formula-syntax/math-functions/log","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3EFiglugR1swOi2FSGHR","title":"MAX","pathname":"/planning-sheets/formula-syntax/math-functions/max","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vhKySa8nxw1HsxzSYfAT","title":"MIN","pathname":"/planning-sheets/formula-syntax/math-functions/min","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"J3Ixjvc37u6ecoy50zVg","title":"MOD","pathname":"/planning-sheets/formula-syntax/math-functions/mod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"87iRaaIkgF8zQ1bb5dcK","title":"MROUND","pathname":"/planning-sheets/formula-syntax/math-functions/mround","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"VNOEuMvgvsechnp3HJLv","title":"NUMBERVALUE","pathname":"/planning-sheets/formula-syntax/math-functions/numbervalue","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"OoXC4lVcrncPNsiqQrVC","title":"PCT","pathname":"/planning-sheets/formula-syntax/math-functions/pct","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"iDlNEDwAUxgvBKZX0Q1Y","title":"POWER","pathname":"/planning-sheets/formula-syntax/math-functions/power","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"FpgyByr276AQGyexzgsS","title":"PRODUCT","pathname":"/planning-sheets/formula-syntax/math-functions/product","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"SrnWvW6IO4XBQDo9cWYW","title":"RAND","pathname":"/planning-sheets/formula-syntax/math-functions/rand","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"cCH0BNIPvuujCbjgWaYU","title":"RANDBETWEEN","pathname":"/planning-sheets/formula-syntax/math-functions/randbetween","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9IftHeKRBsT66Cdtbbi0","title":"ROUND","pathname":"/planning-sheets/formula-syntax/math-functions/round","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"6qKbTEJh9m1uiEax06En","title":"ROUNDDOWN","pathname":"/planning-sheets/formula-syntax/math-functions/rounddown","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"PFEret02HvsFgOhVWdem","title":"ROUNDUP","pathname":"/planning-sheets/formula-syntax/math-functions/roundup","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KI14FGEgbTLR5xxRC2Vx","title":"SORT","pathname":"/planning-sheets/formula-syntax/math-functions/sort","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KKh8oNJNUQ2n3sFqtgeK","title":"SUBTRACT","pathname":"/planning-sheets/formula-syntax/math-functions/subtract","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9fSeuxMzFkSvivzRB75w","title":"SUM","pathname":"/planning-sheets/formula-syntax/math-functions/sum","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"bQSQqzRJ81ZuAhmveCFj","title":"SMALL","pathname":"/planning-sheets/formula-syntax/math-functions/small","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9NMOWKVDC2stURMGJTeq","title":"SQRT","pathname":"/planning-sheets/formula-syntax/math-functions/sqrt","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"TdwoA2okNhO3dwU5u9zh","title":"PMT","pathname":"/planning-sheets/formula-syntax/math-functions/pmt","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BMGkg1oP6zydDkD8zZ0P","title":"Text formatting functions","pathname":"/planning-sheets/formula-syntax/text-formatting-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"JsxnHKVi2GyDn4isikHv","title":"CONCATENATE","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/concatenate","siteSpaceId":"sitesp_ofx2Z","description":"Joins multiple text strings into one single combined text value.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"23x61Jh9B10z08jWhM1M","title":"CONCATALL","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/concatall","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"8TGXVBwfVh6l0ti8spVH","title":"HYPERLINK","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/hyperlink","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"iwdfyXYiptRr3UDNgMM7","title":"LEFT","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/left","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7H4nLGn6MvzW7vilMH9H","title":"LOWER","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/lower","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nmtAbjW05cE6e3qUgo4B","title":"MID","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/mid","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"vPVHsLeoR4HZMAHlbFEK","title":"PROPER","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/proper","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7Ifnl94GmKrz0zQqF5Bg","title":"REPLACE","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/replace","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"XwFAmVMgwDmWVnN733Ia","title":"REPT","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/rept","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"OHZ2AR56yk7gG2AZoFaS","title":"RIGHT","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/right","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eM68wWzZaozymrIFGnJ2","title":"TEXT","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/text","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"ReWAum7B2uv0uIvOdX5b","title":"TRIM","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/trim","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nTTfeHCTKEMhWfKfKIes","title":"UPPER","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/upper","siteSpaceId":"sitesp_ofx2Z","description":"Converts text to uppercase letters.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"Tjz7486zqnWso5drV9Lx","title":"VALUE","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/value","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"QPS0AdBYFCX09xsRHhCL","title":"LEN","pathname":"/planning-sheets/formula-syntax/text-formatting-functions/len","siteSpaceId":"sitesp_ofx2Z","description":"Returns the number of characters in a text string, including spaces and special characters.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eXVJI8jCvDVYjUyn1ywt","title":"Date functions","pathname":"/planning-sheets/formula-syntax/date-functions","siteSpaceId":"sitesp_ofx2Z","description":"Date functions allow you to create, format, extract, calculate, and manipulate date and time values.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"qVfA99bRrGZXkLxjTdI2","title":"DATEADD","pathname":"/planning-sheets/formula-syntax/date-functions/dateadd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wKy6tGd7hpcbDoONmNB3","title":"DATEDIFF","pathname":"/planning-sheets/formula-syntax/date-functions/datediff","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"J9R2BlAJNEsB0L3BC1DC","title":"DAY","pathname":"/planning-sheets/formula-syntax/date-functions/day","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"A4mxYUJbgr8b35z9CxIz","title":"DATE","pathname":"/planning-sheets/formula-syntax/date-functions/date","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"njbkHgs1UW12rEZBTvuY","title":"DATE.SET","pathname":"/planning-sheets/formula-syntax/date-functions/date.set","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"HGH9dH5o8MIGttLPw5Qd","title":"DATE.FORMAT","pathname":"/planning-sheets/formula-syntax/date-functions/date.format","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"bcMGmuvLTr3vDKZfw9qS","title":"SOWEEK","pathname":"/planning-sheets/formula-syntax/date-functions/soweek","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wbjBcP9coYYEOUpLMHyr","title":"SOMONTH","pathname":"/planning-sheets/formula-syntax/date-functions/somonth","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lV0Dp9hDOhu8YEeGd4cf","title":"SOQTR","pathname":"/planning-sheets/formula-syntax/date-functions/soqtr","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"NYBuNeVEWZmG5Ttu7W9g","title":"SOYEAR","pathname":"/planning-sheets/formula-syntax/date-functions/soyear","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8gKgjrCuSOEReXuZ4eqY","title":"EOWEEK","pathname":"/planning-sheets/formula-syntax/date-functions/eoweek","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"niIioqUL1koas300LGwV","title":"EOMONTH","pathname":"/planning-sheets/formula-syntax/date-functions/eomonth","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"MN1p5ucOtTjH4rVEIGM0","title":"EOQTR","pathname":"/planning-sheets/formula-syntax/date-functions/eoqtr","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"YvZG1wFGX1yXoGj1qgKJ","title":"EOYEAR","pathname":"/planning-sheets/formula-syntax/date-functions/eoyear","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"Qk4e6FSt8kPxV3a0pyXm","title":"NETWORKDAYS","pathname":"/planning-sheets/formula-syntax/date-functions/networkdays","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"O5lK39AMduZKUkvCTgIX","title":"ADDDAYS","pathname":"/planning-sheets/formula-syntax/date-functions/adddays","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"N1VC39UfVve2Zcp6TmMl","title":"ADDWEEKS","pathname":"/planning-sheets/formula-syntax/date-functions/addweeks","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"sqI0jB4XJpSmwghRArTv","title":"ADDMONTHS","pathname":"/planning-sheets/formula-syntax/date-functions/addmonths","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"trVFvAdthZUExnaXcvg3","title":"ADDQTRS","pathname":"/planning-sheets/formula-syntax/date-functions/addqtrs","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"vNBFlIVhOprshu2i6J6W","title":"ADDYEARS","pathname":"/planning-sheets/formula-syntax/date-functions/addyears","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"jyoFhX0KIQqrkKSBfjqV","title":"FROMEXCELDATE","pathname":"/planning-sheets/formula-syntax/date-functions/fromexceldate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"cb1rhIEIRnJwf7A5FTLK","title":"MONTH","pathname":"/planning-sheets/formula-syntax/date-functions/month","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"VBYmoI98unLBA8GHFSQx","title":"NOW","pathname":"/planning-sheets/formula-syntax/date-functions/now","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"2a3gIkLJaTFHcvBd2Xgp","title":"PERIOD_RANGE","pathname":"/planning-sheets/formula-syntax/date-functions/period_range","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"jeayVPCxkqe6bLe8cGSd","title":"SHOWDATETIME","pathname":"/planning-sheets/formula-syntax/date-functions/showdatetime","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"LckxaLmqMr2KZAOfj6kp","title":"TIMEZONE","pathname":"/planning-sheets/formula-syntax/date-functions/timezone","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"I0Yj4cbbKI7WZTDeu4D2","title":"TODAY","pathname":"/planning-sheets/formula-syntax/date-functions/today","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lvA0OuKtVw6WEcp8sNXB","title":"TOEXCELDATE","pathname":"/planning-sheets/formula-syntax/date-functions/toexceldate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8yot6HgUik49mFNCaWQJ","title":"YEAR","pathname":"/planning-sheets/formula-syntax/date-functions/year","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"uojh5KjZPJJ5LNHSxbfl","title":"Time intelligence functions","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"1C0FQdV4lT81XwOtP171","title":"AGGREGATE","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/aggregate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"getuJY0EcXytgilW7GAA","title":"FILTER","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/filter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"JQn5z0zutzIWUvNmjhgu","title":"COLUMN_PERIOD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/column_period","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"iy6VcuxDD0yJqKgQO1B6","title":"LASTNDAY","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/lastnday","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"PBjEdEj1ACZgOojxelhU","title":"LASTNMONTH","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/lastnmonth","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"hqWXQxzY8iauxKiR08Ab","title":"LASTNQTR","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/lastnqtr","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"VfOpP8Jr1AfcZCsbY7jd","title":"LASTNYEAR","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/lastnyear","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"A4xz0bZzWFCFPGkltkYF","title":"MONTHPERIOD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/monthperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"FfNPAKNyMCF1TD849F5x","title":"MOVINGAVERAGE","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/movingaverage","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"qv8QTFBHbaCj4WTkzyWD","title":"MOVINGSUM","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/movingsum","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"RF1iMJbqfCTXTicFiXRf","title":"MTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/mtd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"tH7hPOP9x14Sk89VzFet","title":"NEXTNDAY","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/nextnday","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"gcGe5aEdpUV6vlUwLfZG","title":"NEXTNMONTH","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/nextnmonth","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"zsQVHHCKmoXGfHBZUgSP","title":"NEXTNQTR","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/nextnqtr","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"2NuyAp8GkpPQLvp7nA8z","title":"NEXTNYEAR","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/nextnyear","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"7s7ff9NZQCj4V7QnTtJ0","title":"QTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/qtd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"PtMFQZ1tKBJIoLxqdilT","title":"QTRPERIOD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/qtrperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"9g61ULb2G0uklceShu0Q","title":"SHIFT","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/shift","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"OpjFvBwN1RQG4Xo2IGff","title":"TOTALYTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/totalytd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"WvoUs6vZ5txZVaLlnG3K","title":"TOTALQTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/totalqtd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"nnXYHJnXfxMfAihPXnQw","title":"TOTALMTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/totalmtd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"JX1C8SFnCPG0JiHH8JP1","title":"VALUEAT","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/valueat","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"ZnMpVkVR4FNQ88kCZRYE","title":"YEARPERIOD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/yearperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"LYksOE8tIEu380optTv3","title":"YTD","pathname":"/planning-sheets/formula-syntax/time-intelligence-functions/ytd","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"YG8TtafyR5w5jOKcECoL","title":"Other operators","pathname":"/planning-sheets/formula-syntax/other-operators","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"MVJkdAbfiCCBPvcToOEd","title":"Identifiers","pathname":"/planning-sheets/formula-syntax/identifiers","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"fhnhHWYX5qLq8zgulCO2","title":"CLOSEDPERIOD","pathname":"/planning-sheets/formula-syntax/identifiers/closedperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"lMSMyf1KTmmXN8UayiOv","title":"COLUMN.DATE","pathname":"/planning-sheets/formula-syntax/identifiers/column.date","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"1qnEiRLLKCGPtTWSD7K4","title":"COLUMN.PARENT","pathname":"/planning-sheets/formula-syntax/identifiers/column.parent","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"GHpK0vzuKBFuxManFtPP","title":"COLUMNS","pathname":"/planning-sheets/formula-syntax/identifiers/column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"Bt0KWCKjTptCg2rkzwTW","title":"CURRENT_PERIOD","pathname":"/planning-sheets/formula-syntax/identifiers/current_period","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"NQVO7ckd8XRG151qPDw1","title":"DESCENDANTS","pathname":"/planning-sheets/formula-syntax/identifiers/descendants","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"BEW1Q4CefOJlqPcXttOh","title":"FORECAST.CLOSED_END","pathname":"/planning-sheets/formula-syntax/identifiers/forecast.closed_end","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"aHQc1xNuFYunTxoB1Zpf","title":"FORECAST.CLOSED_START","pathname":"/planning-sheets/formula-syntax/identifiers/forecast.closed_start","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"ByF0gSe23a3MsJkIczcI","title":"FORECAST.OPEN_END","pathname":"/planning-sheets/formula-syntax/identifiers/forecast.open_end","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"mwKxAjDpzxdJE4TkKqkL","title":"FORECAST.OPEN_START","pathname":"/planning-sheets/formula-syntax/identifiers/forecast.open_start","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"oVU5dCTOJIwBDSt2VjUF","title":"GROUP INDEX","pathname":"/planning-sheets/formula-syntax/identifiers/group-index","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"8gC6NDHI1vO0pGfM9Jp1","title":"HAS","pathname":"/planning-sheets/formula-syntax/identifiers/has","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"Ic74ErSDqvFiODfxIc6V","title":"HAS_ALL","pathname":"/planning-sheets/formula-syntax/identifiers/has_all","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"dL01OJFx7TDRUVNU85lT","title":"HAS_SOME","pathname":"/planning-sheets/formula-syntax/identifiers/has_some","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"eP7XntJrLX54gyI8eNn7","title":"LEAVES","pathname":"/planning-sheets/formula-syntax/identifiers/leaves","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"80TGfHSAQLijwmeksJhN","title":"LEVEL","pathname":"/planning-sheets/formula-syntax/identifiers/level","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"bGky82ujKbImFOUqb1SC","title":"LOGGEDIN_EMAIL","pathname":"/planning-sheets/formula-syntax/identifiers/loggedin_email","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"wG9aQnyqWDpKf74MDKsz","title":"LOGGEDIN_NAME","pathname":"/planning-sheets/formula-syntax/identifiers/loggedin_name","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"6toyCR7IFU1QHAlGqs5f","title":"MATCH","pathname":"/planning-sheets/formula-syntax/identifiers/match","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"7bUi7XuIknPz7tgifBE6","title":"MAXDATE","pathname":"/planning-sheets/formula-syntax/identifiers/maxdate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"PHCAYiG5jTEW3tWGtcIa","title":"MEMBERS","pathname":"/planning-sheets/formula-syntax/identifiers/members","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"tI6pqXME67JYBUBdmprc","title":"MINDATE","pathname":"/planning-sheets/formula-syntax/identifiers/mindate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"FnmB7oyaFYxp99t51QsW","title":"RELATIVE","pathname":"/planning-sheets/formula-syntax/identifiers/relative","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"53lMUTKH9aPe80lLApT9","title":"RELATIVE_COLUMN","pathname":"/planning-sheets/formula-syntax/identifiers/relative_column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"cKtOh2XD6oIFpXBiQerl","title":"ROW.PARENT","pathname":"/planning-sheets/formula-syntax/identifiers/row.parent","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"YRLjoLdCC6Nu9SzVIVky","title":"ROW.LABEL","pathname":"/planning-sheets/formula-syntax/identifiers/row.label","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"c8wML0XeCmptUsU3Aisg","title":"Scripting functions","pathname":"/planning-sheets/formula-syntax/scripting-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"LLDV5RBYGTrHpPHM0Khk","title":"DISPLAYTOAST","pathname":"/planning-sheets/formula-syntax/scripting-functions/displaytoast","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4GmnEVa5jx53JkCkLWJM","title":"EXPORT","pathname":"/planning-sheets/formula-syntax/scripting-functions/export","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4aVL4ji6z5ezqORkKOpL","title":"LAYOUT","pathname":"/planning-sheets/formula-syntax/scripting-functions/layout","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"Uvn7UVDZCwYpXux7eNid","title":"OPENFILTER","pathname":"/planning-sheets/formula-syntax/scripting-functions/openfilter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"zx5FdTu6Ft3jsPJI2yaj","title":"OPENKPIEXPLORER","pathname":"/planning-sheets/formula-syntax/scripting-functions/openkpiexplorer","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"IYggoazsrSx7yLhuHJNy","title":"OPENMANAGECOLUMN","pathname":"/planning-sheets/formula-syntax/scripting-functions/openmanagecolumn","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KkbsQMI89pCwJwy2Pi4Q","title":"OPENSEARCH","pathname":"/planning-sheets/formula-syntax/scripting-functions/opensearch","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"WIyrK8hj0bD3vnDmpLcj","title":"OPENTOPN","pathname":"/planning-sheets/formula-syntax/scripting-functions/opentopn","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"pL2hKOtmZbtdOgwpo58D","title":"SENDMAIL","pathname":"/planning-sheets/formula-syntax/scripting-functions/sendmail","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EBhDPDhxF8Q2jaQIK1r1","title":"SETCFRULE","pathname":"/planning-sheets/formula-syntax/scripting-functions/setcfrule","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BjzJwN1LySH4qIXvPahD","title":"SETCOLUMNSORT","pathname":"/planning-sheets/formula-syntax/scripting-functions/setcolumnsort","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"UyqFjPmSRPZ30vDqdpDB","title":"SETFILTER","pathname":"/planning-sheets/formula-syntax/scripting-functions/setfilter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"n3DcyJZGOJTC57eTFvlw","title":"SETFILTERBYINDEX","pathname":"/planning-sheets/formula-syntax/scripting-functions/setfilterbyindex","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EFJgsliL5VhlP0wSeSBE","title":"SETFONTSIZE","pathname":"/planning-sheets/formula-syntax/scripting-functions/setfontsize","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"dPscm5R3D0lHhSPMZdP3","title":"SETFOOTER","pathname":"/planning-sheets/formula-syntax/scripting-functions/setfooter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"C9BFvHgLRBk04CN6JVc3","title":"SETHEADER","pathname":"/planning-sheets/formula-syntax/scripting-functions/setheader","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"tPpqVONU7j0GHraFOBut","title":"SETLOCK","pathname":"/planning-sheets/formula-syntax/scripting-functions/setlock","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"oJDbB7oJT9OPgZyNTipm","title":"SETMEASURETITLE","pathname":"/planning-sheets/formula-syntax/scripting-functions/setmeasuretitle","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"VoH2cUmPDXdV5Nzg6NJg","title":"SETMAXDECIMALPRECISION","pathname":"/planning-sheets/formula-syntax/scripting-functions/setmaxdecimalprecision","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"poBtFcBhbxo3xFe3KdEp","title":"SETPAGINATION","pathname":"/planning-sheets/formula-syntax/scripting-functions/setpagination","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"nNlqWPq85ceLsq7oa5oV","title":"SETSCALING","pathname":"/planning-sheets/formula-syntax/scripting-functions/setscaling","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"w50qN7scOF8utUfsr4Ot","title":"SETSEMANTICFORMATTING","pathname":"/planning-sheets/formula-syntax/scripting-functions/setsemanticformatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"neci4NTB6cGptXIWcfEO","title":"SETSTATUSBAR","pathname":"/planning-sheets/formula-syntax/scripting-functions/setstatusbar","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"mlC8yab6rUOvBCGFq80h","title":"SETVALUE","pathname":"/planning-sheets/formula-syntax/scripting-functions/setvalue","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BadWz6cZ3g2vkCHqWf37","title":"SETVISIBILITY","pathname":"/planning-sheets/formula-syntax/scripting-functions/setvisibility","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"Oe1ME4WmbWJJymMznXBW","title":"SHOWBETWEENPERIOD","pathname":"/planning-sheets/formula-syntax/scripting-functions/showbetweenperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"ouwnYuvuaAKu50TsGkGm","title":"SHOWCLOSEDFORECAST","pathname":"/planning-sheets/formula-syntax/scripting-functions/showclosedforecast","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KIfIYACONM1pShrL0sg7","title":"SHOWMEASUREBETWEENPERIOD","pathname":"/planning-sheets/formula-syntax/scripting-functions/showmeasurebetweenperiod","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"42iAW4rINxgPxReb6P78","title":"TOPN","pathname":"/planning-sheets/formula-syntax/scripting-functions/topn","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"e7KJ9e2hU3eXiQQob8IV","title":"DISPLAY SETTINGS","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"0dHCqB6hdGvJqgBaW6QG","title":"SETBLANKLABEL","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/setblanklabel","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"LHPp7khRgkfOeg6dzDay","title":"SETSUPPRESSZEROS","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/setsuppresszeros","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"GE3RkOh1U6H7RKB9A5Yx","title":"SETRAGGEDHIERARCHY","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/setraggedhierarchy","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"fyMZa1h0LmKfgwUuVY44","title":"SEPARATOR","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/separator","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"nadzc0BtlUKKyNI4vurt","title":"SETCOMBINECOLUMNHEADER","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"2f4FRNENJgyL64KOa6jB","title":"SEMANTICFORMAT","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/semanticformat","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"UGWrsro5DJyNHdoLhmRc","title":"SHOWNULLAS","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/shownullas","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"8nTjWaqDYswWJg3IlQIm","title":"SHOWZEROAS","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/showzeroas","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"v9N787dOqyh93Hjqv5rW","title":"SINGLECHILD","pathname":"/planning-sheets/formula-syntax/scripting-functions/display-settings/singlechild","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"VMXodINSF8idYNV272BN","title":"Statistical Functions","pathname":"/planning-sheets/formula-syntax/statistical-functions","siteSpaceId":"sitesp_ofx2Z","description":"Analyze data using statistical functions to summarize, measure variation, and uncover insights.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"QX6spsHVKDZqjGC2artS","title":"MEDIAN","pathname":"/planning-sheets/formula-syntax/statistical-functions/median","siteSpaceId":"sitesp_ofx2Z","description":"Determines the central value in a dataset.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"krEQbLWeU66m6cI3JurZ","title":"MODE","pathname":"/planning-sheets/formula-syntax/statistical-functions/mode","siteSpaceId":"sitesp_ofx2Z","description":"Returns the value with the highest frequency in a dataset.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"x9PCb3AdoFQdqWKLBbwj","title":"MODESNGL","pathname":"/planning-sheets/formula-syntax/statistical-functions/modesngl","siteSpaceId":"sitesp_ofx2Z","description":"Returns the single most frequently occurring value in a dataset. When multiple numbers appear frequently, it returns the first mode.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"SjjIlgQYKJYWgutKzUTu","title":"RANKEQ","pathname":"/planning-sheets/formula-syntax/statistical-functions/rankeq","siteSpaceId":"sitesp_ofx2Z","description":"Returns the position of a number in a list. Newer version of RANK.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"7ICWmNkyeymEjt830eS5","title":"RANKAVG","pathname":"/planning-sheets/formula-syntax/statistical-functions/rankavg","siteSpaceId":"sitesp_ofx2Z","description":"Returns the position of a number in a list. If there are duplicates, this function gives them the average rank.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"WvRcjOVk7Jh5tiy0TK17","title":"QUARTILEINC","pathname":"/planning-sheets/formula-syntax/statistical-functions/quartileinc","siteSpaceId":"sitesp_ofx2Z","description":"Calculate quartiles using the inclusive method to understand data distribution.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"Ch3ZVigqmVrsqA8bccXb","title":"QUARTILEEXC","pathname":"/planning-sheets/formula-syntax/statistical-functions/quartileexc","siteSpaceId":"sitesp_ofx2Z","description":"Calculate quartiles using the exclusive method to understand data distribution.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"OveKuRBVOaKB92MTbbxD","title":"VARS","pathname":"/planning-sheets/formula-syntax/statistical-functions/vars","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the sample variance of a dataset to measure how widely values are spread from the mean.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"IpSbre0SKrwNe6aIm9dp","title":"VARP","pathname":"/planning-sheets/formula-syntax/statistical-functions/varp","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the population variance of a dataset to measure how widely values are spread from the mean.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"W21qsD497ACLgGnA4X7G","title":"STDEVS","pathname":"/planning-sheets/formula-syntax/statistical-functions/stdevs","siteSpaceId":"sitesp_ofx2Z","description":"Measures the sample standard deviation to analyze data variability.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"KbMZEO4t0r8qOYuKgVE3","title":"STDEVP","pathname":"/planning-sheets/formula-syntax/statistical-functions/stdevp","siteSpaceId":"sitesp_ofx2Z","description":"Measures the population standard deviation to analyze data variability.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"UKNZeAam7UPWaPtcuT5g","title":"PERCENTILEINC","pathname":"/planning-sheets/formula-syntax/statistical-functions/percentileinc","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the percentile of a dataset to find the value below which a given percentage of data falls.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"XO8lJ8u4CGEuX6wxZs6q","title":"PERCENTILEEXC","pathname":"/planning-sheets/formula-syntax/statistical-functions/percentileexc","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the exclusive percentile of a dataset to find the value below which a given percentage of data falls.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"tzpescM0c7wblKpbanP8","title":"NORMDIST","pathname":"/planning-sheets/formula-syntax/statistical-functions/normdist","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the normal distribution probability for a specific value based on a given mean and standard deviation.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"kMpTiH6vUbn1O7eES1BR","title":"NORMSDIST","pathname":"/planning-sheets/formula-syntax/statistical-functions/normsdist","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the standard normal distribution probability for a specific value to analyze data variability on a standardized scale.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"BbPFWbP1TdwRmxAj2ovB","title":"NORMINV","pathname":"/planning-sheets/formula-syntax/statistical-functions/norminv","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the inverse normal distribution for a specific probability to determine the corresponding value based on a given mean and standard deviation.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"KrktcSbK0PhCcFzYLv5a","title":"NORMSINV","pathname":"/planning-sheets/formula-syntax/statistical-functions/normsinv","siteSpaceId":"sitesp_ofx2Z","description":"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.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"aJgYHRUidnCD0A6ccvqL","title":"PERCENTRANKINC","pathname":"/planning-sheets/formula-syntax/statistical-functions/percentrank.inc","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the inclusive percentage rank of a value within a dataset to determine its relative position among other values.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"VOpJtfAHDXbHDm8bwuJj","title":"PERCENTRANKEXC","pathname":"/planning-sheets/formula-syntax/statistical-functions/percentrankexc","siteSpaceId":"sitesp_ofx2Z","description":"Calculates the exclusive percentage rank of a value within a dataset to determine its relative position among other values.","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"yuV75wmoqHiuaMfP6iTv","title":"Miscellaneous functions","pathname":"/planning-sheets/formula-syntax/miscellaneous-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"tgd1osdxp2InLMYQhRy9","title":"FETCH","pathname":"/planning-sheets/formula-syntax/miscellaneous-functions/fetch","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"GCJX3L5qUnEsWe8wJ1gr","title":"LOOKUP","pathname":"/planning-sheets/formula-syntax/miscellaneous-functions/lookup","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"CvdjurcX9xjYHS1efSP8","title":"Measure/Column selection functions","pathname":"/planning-sheets/formula-syntax/measure-column-selection-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"}]},{"id":"fGIagCrV70fAp3IK67cG","title":"GETCOLBETWEENPERIODS","pathname":"/planning-sheets/formula-syntax/measure-column-selection-functions/getcolbetweenperiods","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"iZ4HfZZTZDkLABXd3YBG","title":"GETMEASURE","pathname":"/planning-sheets/formula-syntax/measure-column-selection-functions/getmeasure","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"8SmH8nzTlk9Wkg3Ea3nB","title":"SELECT","pathname":"/planning-sheets/formula-syntax/measure-column-selection-functions/select","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"WFhSO3nZhsxAgmxtk2XW","title":"SELECT_BYINDEX","pathname":"/planning-sheets/formula-syntax/measure-column-selection-functions/select_byindex","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"VEjvb7Lk8il7fi70zm0G","title":"Troubleshoot","pathname":"/planning-sheets/troubleshoot","siteSpaceId":"sitesp_ofx2Z","icon":"screwdriver-wrench","breadcrumbs":[{"label":"Planning sheets","icon":"table-cells-header-unlock"}]},{"id":"U7ZquazctbfqnFKPEUJt","title":"PowerTable sheets","pathname":"/powertable-sheets","siteSpaceId":"sitesp_ofx2Z","icon":"database"},{"id":"MO6cmajdVKtSZzriC5MC","title":"Concepts","pathname":"/powertable-sheets/concepts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"}]},{"id":"dc805c9ba2907eb323244357c3de7042c0040f0a","title":"Supported column types","pathname":"/powertable-sheets/concepts/supported-column-types","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"Concepts"}]},{"id":"YAsO2OY2vot4E0MjcLr7","title":"Master-Detail Tables (Parent-Child Linked Records)","pathname":"/powertable-sheets/concepts/master-detail-tables-parent-child-linked-records","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"Concepts"}]},{"id":"ncITMs3U020JgxNP8msL","title":"Type 2 SCDs","pathname":"/powertable-sheets/concepts/type-2-scds","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"Concepts"}]},{"id":"3Y0yYb29hDtFApWXlTdp","title":"Automation","pathname":"/powertable-sheets/concepts/automation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"Concepts"}]},{"id":"aMXgfTxfc79qqghkwtr9","title":"How-tos","pathname":"/powertable-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"}]},{"id":"1TGQU17AOVTSvx7X2IIl","title":"Build a no-code table app with PowerTable","pathname":"/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"c2IKHSV0LhbpY24wmfBY","title":"Connect PowerTable sheet to a semantic model","pathname":"/powertable-sheets/how-tos/connect-powertable-sheet-to-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"tT80TQzsvkntHUi2WKy0","title":"Connect to a Database","pathname":"/powertable-sheets/how-tos/connect-to-a-database","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"iBIMXtjC9x0v8EI0Dw3f","title":"Enter Data Manually","pathname":"/powertable-sheets/how-tos/enter-data-manually","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"teWzpI7UxTaQmULq37Dw","title":"Basic Table Operations","pathname":"/powertable-sheets/how-tos/basic-table-operations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"9b9a91abafae7b92393ed7e92e2b16ea8d5825bf","title":"Edit and Bulk-edit data","pathname":"/powertable-sheets/how-tos/basic-table-operations/edit-and-bulk-edit-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic Table Operations"}]},{"id":"xsowk8f2TSywWLPJpIOe","title":"Preview Changes","pathname":"/powertable-sheets/how-tos/basic-table-operations/preview-changes","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic Table Operations"}]},{"id":"a9179689701ae2bda3829d8a7596c17fabfdc62c","title":"Insert, Import, Duplicate and Delete Rows","pathname":"/powertable-sheets/how-tos/insert-import-duplicate-and-delete-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"8023aeee8209173d38ab88d9a11e5825a2f4bac6","title":"Adding Columns - Overview","pathname":"/powertable-sheets/how-tos/adding-columns-overview","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"c575729f8aeca15ada3ad53d0ed2e53c55fed90b","title":"Add visual column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"}]},{"id":"ae1c321761d999343109cb5f3851c8ff42311328","title":"Multi-select Relationship Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"},{"label":"Add visual column"}]},{"id":"283c75c151dad9d0b96740c138ed9f39a137e9b0","title":"Reference Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"},{"label":"Add visual column"}]},{"id":"7a3299a7d6ef877f05982d116a793aa89abf55b6","title":"Relation Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/relation-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"},{"label":"Add visual column"}]},{"id":"fa9406e8aad127728b03de1fb275c17fa67f8d06","title":"Button Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/button-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"},{"label":"Add visual column"}]},{"id":"9e53934a2f39e99256c3a0ccbfe00f0b20716cd2","title":"Attachments Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/attachments-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"},{"label":"Add visual column"}]},{"id":"7da2eb3f2b327dc0fadddfbcc2b92d2782c2d1e0","title":"Add Database Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-database-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"}]},{"id":"c11350c45d8894603daaf0839a8f0951851c83b4","title":"Add Formula Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-formula-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding Columns - Overview"}]},{"id":"d1f6cf9199e2de9083880ad48b48ec4e0a887553","title":"Configure Column Properties","pathname":"/powertable-sheets/how-tos/configure-column-properties","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ff5d993b3716c2851407fbc743a53ae5eb28c80e","title":"Display","pathname":"/powertable-sheets/how-tos/configure-column-properties/display","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure Column Properties"}]},{"id":"43a382c2b2837292159d8423d6e01e66424cfa56","title":"General","pathname":"/powertable-sheets/how-tos/configure-column-properties/general","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure Column Properties"}]},{"id":"80863bc933c5ae576c37853b781ef44bd7675bd4","title":"Lookup and Relation","pathname":"/powertable-sheets/how-tos/configure-column-properties/lookup-and-relation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure Column Properties"}]},{"id":"90XL7RDRQVxktYqNKFIi","title":"Set up row and column access control","pathname":"/powertable-sheets/how-tos/set-up-row-and-column-access-control","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"5247964e6086f421316bb292a701da517fa31110","title":"Manage Columns","pathname":"/powertable-sheets/how-tos/manage-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ebc1d58ec9b06b5b848b436216cdf620455df4d8","title":"Change Column Widths","pathname":"/powertable-sheets/how-tos/manage-columns/change-column-widths","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage Columns"}]},{"id":"7f41d8d534868b21a74a65364179abf6add1e384","title":"Layout Views - Summary","pathname":"/powertable-sheets/how-tos/layout-views-summary","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"decda3fe2c1e7b4bcb39435573e59321e296e408","title":"Gantt Chart View","pathname":"/powertable-sheets/how-tos/layout-views-summary/gantt-chart-view","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Layout Views - Summary"}]},{"id":"8118532677a619d6e9340551bce268149ebe98c7","title":"Resource Gantt","pathname":"/powertable-sheets/how-tos/layout-views-summary/resource-gantt","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Layout Views - Summary"}]},{"id":"071719f5aba1b9c348821704e61fa2052add04a0","title":"Hierarchy Layout","pathname":"/powertable-sheets/how-tos/layout-views-summary/hierarchy-layout","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Layout Views - Summary"}]},{"id":"NnmvdHyyKHJSf6fVtPh7","title":"Create data entry forms","pathname":"/powertable-sheets/how-tos/generate-forms","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"QEYkFb5oxJWLQg5ACH5f","title":"Approval flow","pathname":"/powertable-sheets/how-tos/approval-flow","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"azKSmaWp8Z4BPdMdBIcU","title":"Configure approval workflow","pathname":"/powertable-sheets/how-tos/approval-flow/configure-approval-workflow","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"7DP9tAXqTqytlNCynmCZ","title":"Review changes in PowerTable approval workflow","pathname":"/powertable-sheets/how-tos/approval-flow/review-changes-in-powertable-approval-workflow","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"zKFPwBdMrBmhYB56SiQJ","title":"Collaborative Commenting","pathname":"/powertable-sheets/how-tos/collaborative-commenting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"d33a26c0fdfb81aea506e22fc01a0cf0e70c4eff","title":"View all comments & track changes","pathname":"/powertable-sheets/how-tos/collaborative-commenting/view-all-comments-and-track-changes","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collaborative Commenting"}]},{"id":"8e832b951d875eae992bf601d592a89d63905e3e","title":"Assign users & task status","pathname":"/powertable-sheets/how-tos/collaborative-commenting/assign-users-and-task-status","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collaborative Commenting"}]},{"id":"FeqsyI3m8UlqLY8AyNVI","title":"Conditional Formatting","pathname":"/powertable-sheets/how-tos/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"HC7jnJ4OStgvDFjwf7UO","title":"Audit log","pathname":"/powertable-sheets/how-tos/audit-log","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PowerTable sheets","icon":"database"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"7lqE4ATHS0bLIEeSrFrX","title":"Intelligence sheets","pathname":"/intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","icon":"head-side-gear"},{"id":"iyINGCFbJ6iGmmK7zSAb","title":"How-tos","pathname":"/intelligence-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"}]},{"id":"Le56AiOcpKpxNQoxDRxe","title":"Get started with Intelligence sheets","pathname":"/intelligence-sheets/how-tos/get-started-with-intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ahmVnWS0Dd5GaJOnIPHD","title":"Apply conditional formatting","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZJPmNKa5xg6k9jUFOjYN","title":"Showcase data points in charts","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/showcase-data-points-in-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"cgvjzLWX04Gn8dhIGhPP","title":"Highlight tabular data with conditional formatting","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/highlight-tabular-data-with-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"txnVsNgKPu71v2Yo9wls","title":"Create rules","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/create-rules","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"SsibLLqx7GCpXlj9XkHn","title":"Build financial reports","pathname":"/intelligence-sheets/how-tos/build-financial-reports","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hZzZD6HvBNynva3tVI3u","title":"Collaborate on reports with comments","pathname":"/intelligence-sheets/how-tos/collaborate-on-reports-with-comments","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"GmHllVsQoNnbrQ1s4kXB","title":"Pagination and formatting for Reports","pathname":"/intelligence-sheets/how-tos/pagination-and-formatting-for-reports","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hlrllHW4TQfaK2fhqlj9","title":"Export high-quality PDF & Excel reports","pathname":"/intelligence-sheets/how-tos/export-high-quality-pdf-and-excel-reports","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"xD7g8p48pvAtcOdOjt0p","title":"Visualize simulations, budgets, and forecasts","pathname":"/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ECVJ25muQ9oGi5S1F7I3","title":"Plan projects with Gantt charts","pathname":"/intelligence-sheets/how-tos/plan-projects-with-gantt-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Im1Ut4RCY3J7o7p2TPyx","title":"Retain report data with Writeback","pathname":"/intelligence-sheets/how-tos/retain-report-data-with-writeback","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hbu6vyGjJ5MI99chhmjx","title":"Build multi-measure charts","pathname":"/intelligence-sheets/how-tos/build-multi-measure-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"82NC1fKYnMWbQj4F0l7X","title":"Use themes for consistent color schemes","pathname":"/intelligence-sheets/how-tos/use-themes-for-consistent-color-schemes","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"4hM00zGijWU9r82TkkY4","title":"Ranking data","pathname":"/intelligence-sheets/how-tos/ranking-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"6jGqLfKPCf7K2qtUaIAF","title":"Sorting data","pathname":"/intelligence-sheets/how-tos/sorting-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Intelligence sheets","icon":"head-side-gear"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"9btFGkfNsBdI76WrBF0E","title":"Infobridge","pathname":"/infobridge","siteSpaceId":"sitesp_ofx2Z","icon":"link-horizontal"},{"id":"s4x1DfmxW0Y2LFl1pC37","title":"How-tos","pathname":"/infobridge/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"SwliBW8cfMAgmOF5LQFJ","title":"Create a bridge to integrate and transform plans","pathname":"/infobridge/how-tos/1.-create-bridge","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"u65ZysHGAjgprogpaO4j","title":"Import measures between Planning sheets","pathname":"/infobridge/how-tos/import-measures-between-planning-sheets","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Due8bZcgEc8DXe0Z7syN","title":"Import data into a bridge","pathname":"/infobridge/how-tos/2.-add-source-to-bridge","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"N1eiwDxiZdnKEzto3NKk","title":"Manage query operations","pathname":"/infobridge/how-tos/4.-manage-queries","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0TS4J0E33GNr4HbAEGk3","title":"Query transformations","pathname":"/infobridge/how-tos/4.-manage-queries/query-transformations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage query operations"}]},{"id":"0J2TTBFDgV32nvKoVYJZ","title":"Append","pathname":"/infobridge/how-tos/4.-manage-queries/query-transformations/append","siteSpaceId":"sitesp_ofx2Z","description":"In the module, we'll explore how to use append functions to combine data with the same structure from multiple tables.","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage query operations"},{"label":"Query transformations"}]},{"id":"pj8VL7MKD6uygSzslN1y","title":"Join","pathname":"/infobridge/how-tos/4.-manage-queries/query-transformations/join","siteSpaceId":"sitesp_ofx2Z","description":"Explore how to leverage joins to retrieve data from multiple tables using a related column.","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage query operations"},{"label":"Query transformations"}]},{"id":"wHTh7ao4ohJDVyKWncdF","title":"Duplicate","pathname":"/infobridge/how-tos/4.-manage-queries/query-transformations/duplicate","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage query operations"},{"label":"Query transformations"}]},{"id":"D04fG5CuRWDf2TK9QNbM","title":"Writeback transformed data from InfoBridge","pathname":"/infobridge/how-tos/writeback-transformed-data-from-infobridge","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"AIzgJUwcprYcoeml0Ioj","title":"4. Manage sources","pathname":"/infobridge/4.-manage-sources","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"M0gdRdBqWTFZrCz20tgr","title":"5. Insert rows from bridge","pathname":"/infobridge/5.-insert-rows-from-bridge","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"KYeQc8xI7s7Jjgrtd1cu","title":"6. Insert measure from bridge","pathname":"/infobridge/6.-insert-measure-from-bridge","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"srfLlm3pX35yn9JDglvM","title":"7. Manage Integration of Plan items","pathname":"/infobridge/7.-manage-integration-of-visuals","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"y9m7l68EiUJftNnNX0dJ","title":"8. Manage Bridges","pathname":"/infobridge/8.-manage-bridges","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"AzpcSN8sE56mSHM47fUF","title":"9. Data transformations","pathname":"/infobridge/9.-data-transformations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"J4bavjbHMVxbDFYtWlAy","title":"Pivot table","pathname":"/infobridge/9.-data-transformations/pivot-table","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"CPDZdDHgwR7CblAEXH0G","title":"Group by","pathname":"/infobridge/9.-data-transformations/group-by","siteSpaceId":"sitesp_ofx2Z","description":"Learn how to aggregate and summarize detailed reports with the Group by transformation.","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"73iilL9z3zPsEWOKtLXK","title":"Add Column","pathname":"/infobridge/9.-data-transformations/add-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"867ZKHK8aGH5iVSN5rZW","title":"Pivot column","pathname":"/infobridge/9.-data-transformations/pivot-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"jcCJk0Hl3LnUaWwjXQrM","title":"Rename column","pathname":"/infobridge/9.-data-transformations/rename-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"tzCCeKDTMQLz9I5zyAdP","title":"Find and Replace","pathname":"/infobridge/9.-data-transformations/find-and-replace","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"jnD1KlvD2vo0iflysqZi","title":"Remove measure","pathname":"/infobridge/9.-data-transformations/remove-measure","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"ro9I4AjYQz0PM0FCGwhR","title":"Filter rows","pathname":"/infobridge/9.-data-transformations/filter-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"COXIDBv7XAuhHt5LMJgX","title":"Sort","pathname":"/infobridge/9.-data-transformations/sort","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"Ly6p3rDbZ27mvCMcbeoM","title":"Text functions","pathname":"/infobridge/9.-data-transformations/text-functions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"qpCn2vy5qKHr4EkTMBGB","title":"Unnest","pathname":"/infobridge/9.-data-transformations/unnest","siteSpaceId":"sitesp_ofx2Z","description":"Learn how to use the Unnest transformation to convert delimited values into separate rows and flatten your data.","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"7keiq1ADO3o6VidDobgp","title":"Round","pathname":"/infobridge/9.-data-transformations/round","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"FOIZm9oj58hUm8ASGkNP","title":"Extract Comments","pathname":"/infobridge/9.-data-transformations/extract-comments","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"woCB0ecyr7qlomX7AsQB","title":"Import and export","pathname":"/infobridge/9.-data-transformations/import-and-export","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"},{"label":"9. Data transformations"}]},{"id":"SrTYNUKRUtIQFREqCCyj","title":"10. Integrating forecasts","pathname":"/infobridge/10.-integrating-forecasts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"gchWDZWsm99uxZCuLwOh","title":"11. Collaborative adjustments","pathname":"/infobridge/11.-collaborative-adjustments","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"2jqs5GNkNpVvjhnQKyP4","title":"Infobridge sheets in Plan (preview)","pathname":"/infobridge/infobridge-sheets-in-plan-preview","siteSpaceId":"sitesp_ofx2Z","icon":"layer-plus","breadcrumbs":[{"label":"Infobridge","icon":"link-horizontal"}]},{"id":"4UBOKUbu8tzlmfy99nUP","title":"Guides","pathname":"/guides","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines"},{"id":"fgHv1S4oLtZcqSlkATdb","title":"Creating a Forecast","pathname":"/guides/creating-a-forecast","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Guides","icon":"book-open-lines"}]}]}