{"version":1,"pages":[{"id":"wrJjhh6HimasChVFwsji","title":"Plan","pathname":"/","siteSpaceId":"sitesp_ofx2Z","icon":"bullseye-arrow","description":"No-code, Full-stack Planning + BI + Data Management Suite on Microsoft Fabric","breadcrumbs":[{"label":"Documentation","icon":"dochub"}]},{"id":"xunEw97oaOkyBKj7GBrm","title":"Prerequisites for Plan","pathname":"/documentation/plan/prerequisites-for-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"uz01O120wTPdTlm5Wt1x","title":"Known Limitations in Plan (Preview)","pathname":"/documentation/plan/known-limitations-in-plan-preview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"yhoI2pskOHnFzCj1xx8z","title":"Row-level security (RLS) behavior in Plan","pathname":"/documentation/plan/row-level-security-rls-behavior-in-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"zOhzSeRQbAUSwDMtArUH","title":"Roles in Fabric Plan","pathname":"/documentation/plan/roles-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"piMMh2mfCLj8sXj4iasf","title":"Disaster recovery for Plan","pathname":"/documentation/plan/disaster-recovery-for-plan","siteSpaceId":"sitesp_ofx2Z","description":"Experience-Specific Recovery Procedures for Planning in Fabric IQ","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"ugICQJZi6XrRJhspZBOt","title":"Planning sheets","pathname":"/documentation/plan/planning-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"PBLXVykHutcb9mbM6PGn","title":"Concepts","pathname":"/documentation/plan/planning-sheets/concepts","siteSpaceId":"sitesp_ofx2Z","icon":"calendar-check","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"}]},{"id":"rJ5k2GPOnQgjpLAVVcxe","title":"Fiscal year in planning and reporting","pathname":"/documentation/plan/planning-sheets/concepts/fiscal-year-in-planning-and-reporting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"HoMzr5CZ2itPMqivoLi8","title":"Cube","pathname":"/documentation/plan/planning-sheets/concepts/cube","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"hQuoBmOCAhyVsgMsvmLC","title":"How-tos","pathname":"/documentation/plan/planning-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"}]},{"id":"cdI66wSzhRixH7PvQYSJ","title":"Create and share a cloud connection for a semantic model","pathname":"/documentation/plan/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"32udHuAAnrjaoP9YGb2K","title":"Creating a Planning Sheet","pathname":"/documentation/plan/planning-sheets/how-tos/creating-a-planning-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hjgalITOm5gNjp3btmJ7","title":"Create a database connection for collaboration","pathname":"/documentation/plan/planning-sheets/how-tos/create-a-database-connection-for-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"C3eNamsIHNBzkFaH2sS6","title":"Forecast data to predict future trends","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"56ZdqBvao2mImGLgoziF","title":"Create multi-dimensional forecasts","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"Q99ASWXN01SpgGbXXIZY","title":"Manage rolling forecasts","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"enG17VIVLgDrBqarBz2x","title":"Generate forecasts from statistical data","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"JmRtfblb2NGqw4WYPcpz","title":"Extend planning beyond source data periods","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"lVABeURDpuO7AZw9OsMR","title":"Edit forecast settings","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"CV1J3gR5V3v6mzIGwhey","title":"Allocate deficits to meet targets","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"HniHNJWrX8BFWDGuQ1Km","title":"Forecasting FAQ","pathname":"/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/forecasting-faq","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"reUhWMJReoPJx3nMOebV","title":"Commenting and collaboration","pathname":"/documentation/plan/planning-sheets/how-tos/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"nao19jxgUlvWKmZe4Dws","title":"Notes in Commenting and Collaboration","pathname":"/documentation/plan/planning-sheets/how-tos/commenting-and-collaboration/notes-in-commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Commenting and collaboration"}]},{"id":"5NujCR2SrMNR09b0W5R5","title":"Extend Planning sheet with data input","pathname":"/documentation/plan/planning-sheets/how-tos/extend-planning-sheet-with-data-input","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ojfVbC8weTCSyrmD2svw","title":"Plan across multiple dimensions with cubes","pathname":"/documentation/plan/planning-sheets/how-tos/allocate-values-across-dimensions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"1n70ugrLLDOPJM1ttzWl","title":"Analyze planning outcomes with scenarios","pathname":"/documentation/plan/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"StOkLWFlLNX7jrBGKH9m","title":"Bookmarks","pathname":"/documentation/plan/planning-sheets/how-tos/bookmarks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ogdxreRx6iCfHv6dV18I","title":"Exports in the Planning sheet","pathname":"/documentation/plan/planning-sheets/how-tos/exports-in-the-planning-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ljF8Vd8hRu34ByjfZDHt","title":"Pivot","pathname":"/documentation/plan/planning-sheets/how-tos/pivot","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"wkUDlmQTLrz6mBXv8FNM","title":"Layouts","pathname":"/documentation/plan/planning-sheets/how-tos/layouts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"NJKIjeK5xkYfXFeJnoCI","title":"Conditional formatting","pathname":"/documentation/plan/planning-sheets/how-tos/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"blr1sXqrk99n458u3l7r","title":"Create rules in Conditional Formatting","pathname":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"TLJLKSaQ412kvGUi6tUJ","title":"Format by Rules (If conditions) in conditional formatting","pathname":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"luE2mAltuHVcCvqalzIa","title":"Quick formatting options","pathname":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/quick-formatting-options","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"4VWIF6r8UVi3Fr8WETny","title":"Manage Rules","pathname":"/documentation/plan/planning-sheets/how-tos/conditional-formatting/manage-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Conditional formatting"}]},{"id":"FjnLgf3NSz36MS9nYheM","title":"Persist data with Writeback","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"LBWy9L9l6V46sFmatyuV","title":"Writeback in Plan","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/writeback-in-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"ZBLm8CHg8M8z77AiVqqz","title":"General Settings","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/general-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"KdigUkMbNEWZ0ON80azs","title":"Data Settings","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/data-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"Zwuzsh1Id7CpkQ4dHAtx","title":"Destination Settings","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/destination-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"5kLqldRHvClIYmRWO6C4","title":"Configure advanced settings","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"LECa1REKl1ZFEcFdLvXo","title":"Configure writeback destinations","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-writeback-destinations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"4SdrxPiQ52gYjlEteuU7","title":"View Logs","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/view-logs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"UARhSdHLBI4rGMK6Ake1","title":"Enable writeback in reading mode","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/enable-writeback-in-reading-mode","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"7qlFuQ6aPHy2URrEJuWh","title":"FAQs on Writeback","pathname":"/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/faqs-on-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Persist data with Writeback"}]},{"id":"2IGnqW2o1Vcnn3kSWp2I","title":"Basic formatting","pathname":"/documentation/plan/planning-sheets/how-tos/basic-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"EyGNjzwqnB1ukDRJfEyq","title":"Number formatting","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"DdORdsuq4X3JclMGYIdo","title":"Cell, header & value formatting","pathname":"/documentation/plan/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"lSwDqdFQXNVTpL2udjqI","title":"Total and Subtotals","pathname":"/documentation/plan/planning-sheets/how-tos/basic-formatting/total-and-subtotals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"IyCVP7zLYoBmUuowRyDd","title":"Adding business logic and formulas","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"OMtmpKnMz1GVW7YLaILZ","title":"Edit cells","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"uZWWkdI8Mv8u79Zim6Bo","title":"Rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"jSIgD4V7zFEb7piAT7XT","title":"Insert data input rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"scV8vUppjZTho20bqdmC","title":"Insert template rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/template-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"LKop9ZyaVJubQf3gshCj","title":"Insert formula rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"gxazJQpGQs6lmYyUO1WW","title":"Insert blank rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-blank-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"AIvCvRvyYsV4oY5sGC4H","title":"Insert forecast rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Rows"}]},{"id":"pchxDbba98RbD3fElSgm","title":"Measures and Columns","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"lJKvzuF7vHqgAxSIHXkl","title":"Insert data input columns","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"}]},{"id":"d1U162wTDoFssKWgWuRI","title":"Number","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"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":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-calculated-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Measures and Columns"}]},{"id":"ZcrSbaWuo8gTHQBXoVvZ","title":"Manage inserted rows","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"RAEFEzKcwtq8fnuE5khV","title":"Manage inserted measures & columns","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns-1","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"UGa4ygn5Q0KwCMzGGz6G","title":"Manage aggregation","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"}]},{"id":"SD9pAFc5pPpTQoR77RwI","title":"Row aggregation","pathname":"/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation/row-aggregation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Adding business logic and formulas"},{"label":"Manage aggregation"}]},{"id":"lCg9K2VWet47fjVESeVN","title":"Driver Model","pathname":"/documentation/plan/planning-sheets/how-tos/model-builder","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"xfiMOgyqnLoMBuvoTxlN","title":"Configure row properties in the model","pathname":"/documentation/plan/planning-sheets/how-tos/configure-row-properties-in-the-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"d6rs7TRO1z2GvfBoZB1L","title":"Create a model using Model Builder","pathname":"/documentation/plan/planning-sheets/how-tos/create-a-model-using-model-builder","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0ODTeMsLrVn037bb0q6D","title":"Create templates for reusable row structures","pathname":"/documentation/plan/planning-sheets/how-tos/create-templates-for-reusable-row-structures","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"7Az90ELevX5Pj7yxkMOs","title":"Create a driver-based model","pathname":"/documentation/plan/planning-sheets/how-tos/create-a-driver-based-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Q1HWbQ9Q5w1WySW0P4Gd","title":"Tree view","pathname":"/documentation/plan/planning-sheets/how-tos/tree-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZVYVHUlpNUDkd5L33BKQ","title":"Visualize the model using the tree layout","pathname":"/documentation/plan/planning-sheets/how-tos/visualize-the-model-using-the-tree-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"S2Sdr6Saw4BGfC96D9Ad","title":"Optimize overview","pathname":"/documentation/plan/planning-sheets/how-tos/optimize-overview","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"rfNcrBftrfcyt31I0pwc","title":"Maximize or minimize a target value","pathname":"/documentation/plan/planning-sheets/how-tos/optimize-overview/maximize-or-minimize-a-target-value","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Optimize overview"}]},{"id":"U0FBYMlrBSZ8qQf7i6Vp","title":"Optimize input values to meet a target","pathname":"/documentation/plan/planning-sheets/how-tos/optimize-overview/optimize-input-values-to-meet-a-target","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Optimize overview"}]},{"id":"WMoGzdr3EL0UqutiytaA","title":"Configure approval workflows","pathname":"/documentation/plan/planning-sheets/how-tos/configure-approval-workflows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"aImJZ00e4aDW0TQJRJ64","title":"Measure based modelling","pathname":"/documentation/plan/planning-sheets/how-tos/measure-based-modelling","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZFTFsgwv0bRdrLoSHcmC","title":"Formula syntax","pathname":"/documentation/plan/planning-sheets/formula-syntax","siteSpaceId":"sitesp_ofx2Z","icon":"function","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"}]},{"id":"sa4NQI7P13MQxpK5GuRE","title":"Conditional statements","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"6ncprsZrxfdDkhQqJjzD","title":"IF","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/if-1","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"kpV70s7pDTMSFZYVw42Y","title":"IFNA","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/ifna","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"OmwDdnAK2dkOY0S3FhYJ","title":"AVERAGEIF","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/if","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"iECGUFe2ReeJVSry1GSt","title":"COUNTIF","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/countif","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"XIeCjaoVGMXYSBB69OuQ","title":"SUMIF","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/sumif","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"I7lPfAjhtweIMLU9AgMU","title":"FILTERIF","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/filterif","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"lpQusNFc5ikkcgPkPBGv","title":"SWITCH","pathname":"/documentation/plan/planning-sheets/formula-syntax/conditional-statements/switch","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Conditional statements"}]},{"id":"nszR6GLXPDZRYJlf8uo1","title":"Logical functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/logical-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"P6N0doSC1PFoNpCmBvEn","title":"AND","pathname":"/documentation/plan/planning-sheets/formula-syntax/logical-functions/and","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"bxrdTCnz4iqwTAxkLNzT","title":"OR","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"Yo9eM1NYF4GmTQJzZtKk","title":"NOT","pathname":"/documentation/plan/planning-sheets/formula-syntax/logical-functions/not","siteSpaceId":"sitesp_ofx2Z","description":"Reverses a logical result and returns the opposite boolean value","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"atCcWniv5j24vVzCjKsu","title":"XOR","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"hnfkKtUDry7uYYkqSbMN","title":"IN","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"xwYXz9yPz1Y6m1fpK2LH","title":"ISBLANK","pathname":"/documentation/plan/planning-sheets/formula-syntax/logical-functions/isblank","siteSpaceId":"sitesp_ofx2Z","description":"Checks whether a cell is blank and returns TRUE or FALSE.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"kxKdlOJYXGJvrGISXVzk","title":"ISNUMBER","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"q3VkPQYAADLjTYE1oNIe","title":"ISREFEXIST","pathname":"/documentation/plan/planning-sheets/formula-syntax/logical-functions/isrefexist","siteSpaceId":"sitesp_ofx2Z","description":"Verifies whether a reference exists and returns a logical result.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Logical functions"}]},{"id":"Y712qvACJKscliWpkgIR","title":"Math functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"UsCxpkfhBIeCpvlqnWNx","title":"ABS","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/abs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"JBoRRVj5qT9rdqIsWmtw","title":"AVERAGE","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/average","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"NEn6c0ucJMJS3HRphoBE","title":"AVERAGEEXNEG","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexneg","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BadHKyTHhL5Jow3IfqDe","title":"AVERAGEEXZERO","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexzero","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3272xD4VM7ZllCoffQFK","title":"AVERAGEEXZERONEG","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexzeroneg","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vEPEvcXwCO46Tdsva8MD","title":"CEILING","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/ceiling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Yz1XlakVaVicTypHYc3w","title":"COUNT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/count","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"qxOMGC31bXZW9HrCyx8q","title":"DIVIDE","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/divide","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"QKvQ7PxOJVtutBvts03M","title":"EVEN","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/even","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"emWtv4FFTn04pXfhw6DX","title":"EXP","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/exp","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"gF0dt7epJsFddE5eH4uz","title":"ODD","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/odd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"m0JQYMdN9r3n5IyAT1dD","title":"FLOOR","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/floor","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"WqBOIHuaEwVDQqdaauFH","title":"INDEXOF","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/indexof","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Z4U3PCqjuI5n6wBj6ubh","title":"LARGE","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/large","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Wr4yqb6iXLHD5zRNRU0l","title":"LOG","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/log","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3EFiglugR1swOi2FSGHR","title":"MAX","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/max","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vhKySa8nxw1HsxzSYfAT","title":"MIN","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/min","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"J3Ixjvc37u6ecoy50zVg","title":"MOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/mod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"87iRaaIkgF8zQ1bb5dcK","title":"MROUND","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/mround","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"VNOEuMvgvsechnp3HJLv","title":"NUMBERVALUE","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/numbervalue","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"OoXC4lVcrncPNsiqQrVC","title":"PCT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/pct","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"iDlNEDwAUxgvBKZX0Q1Y","title":"POWER","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/power","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"FpgyByr276AQGyexzgsS","title":"PRODUCT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/product","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"SrnWvW6IO4XBQDo9cWYW","title":"RAND","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/rand","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"cCH0BNIPvuujCbjgWaYU","title":"RANDBETWEEN","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/randbetween","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9IftHeKRBsT66Cdtbbi0","title":"ROUND","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/round","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"6qKbTEJh9m1uiEax06En","title":"ROUNDDOWN","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/rounddown","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"PFEret02HvsFgOhVWdem","title":"ROUNDUP","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/roundup","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KI14FGEgbTLR5xxRC2Vx","title":"SORT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/sort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KKh8oNJNUQ2n3sFqtgeK","title":"SUBTRACT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/subtract","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9fSeuxMzFkSvivzRB75w","title":"SUM","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/sum","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"bQSQqzRJ81ZuAhmveCFj","title":"SMALL","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/small","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9NMOWKVDC2stURMGJTeq","title":"SQRT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/sqrt","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"TdwoA2okNhO3dwU5u9zh","title":"PMT","pathname":"/documentation/plan/planning-sheets/formula-syntax/math-functions/pmt","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BMGkg1oP6zydDkD8zZ0P","title":"Text formatting functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"JsxnHKVi2GyDn4isikHv","title":"CONCATENATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/concatenate","siteSpaceId":"sitesp_ofx2Z","description":"Joins multiple text strings into one single combined text value.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"23x61Jh9B10z08jWhM1M","title":"CONCATALL","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/concatall","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"8TGXVBwfVh6l0ti8spVH","title":"HYPERLINK","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/hyperlink","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"iwdfyXYiptRr3UDNgMM7","title":"LEFT","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/left","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7H4nLGn6MvzW7vilMH9H","title":"LOWER","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/lower","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nmtAbjW05cE6e3qUgo4B","title":"MID","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/mid","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"vPVHsLeoR4HZMAHlbFEK","title":"PROPER","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/proper","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7Ifnl94GmKrz0zQqF5Bg","title":"REPLACE","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/replace","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"XwFAmVMgwDmWVnN733Ia","title":"REPT","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/rept","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"OHZ2AR56yk7gG2AZoFaS","title":"RIGHT","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/right","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eM68wWzZaozymrIFGnJ2","title":"TEXT","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/text","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"ReWAum7B2uv0uIvOdX5b","title":"TRIM","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/trim","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nTTfeHCTKEMhWfKfKIes","title":"UPPER","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/upper","siteSpaceId":"sitesp_ofx2Z","description":"Converts text to uppercase letters.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"Tjz7486zqnWso5drV9Lx","title":"VALUE","pathname":"/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/value","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"QPS0AdBYFCX09xsRHhCL","title":"LEN","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eXVJI8jCvDVYjUyn1ywt","title":"Date functions","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"qVfA99bRrGZXkLxjTdI2","title":"DATEADD","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/dateadd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wKy6tGd7hpcbDoONmNB3","title":"DATEDIFF","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/datediff","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"J9R2BlAJNEsB0L3BC1DC","title":"DAY","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/day","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"A4mxYUJbgr8b35z9CxIz","title":"DATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"HGH9dH5o8MIGttLPw5Qd","title":"DATE.FORMAT","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/date.format","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"bcMGmuvLTr3vDKZfw9qS","title":"SOWEEK","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/soweek","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wbjBcP9coYYEOUpLMHyr","title":"SOMONTH","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/somonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lV0Dp9hDOhu8YEeGd4cf","title":"SOQTR","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/soqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"NYBuNeVEWZmG5Ttu7W9g","title":"SOYEAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/soyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8gKgjrCuSOEReXuZ4eqY","title":"EOWEEK","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/eoweek","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"niIioqUL1koas300LGwV","title":"EOMONTH","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/eomonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"MN1p5ucOtTjH4rVEIGM0","title":"EOQTR","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/eoqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"YvZG1wFGX1yXoGj1qgKJ","title":"EOYEAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/eoyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"Qk4e6FSt8kPxV3a0pyXm","title":"NETWORKDAYS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/networkdays","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"O5lK39AMduZKUkvCTgIX","title":"ADDDAYS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/adddays","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"N1VC39UfVve2Zcp6TmMl","title":"ADDWEEKS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/addweeks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"sqI0jB4XJpSmwghRArTv","title":"ADDMONTHS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/addmonths","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"trVFvAdthZUExnaXcvg3","title":"ADDQTRS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/addqtrs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"vNBFlIVhOprshu2i6J6W","title":"ADDYEARS","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/addyears","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"jyoFhX0KIQqrkKSBfjqV","title":"FROM_EXCELDATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/fromexceldate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"cb1rhIEIRnJwf7A5FTLK","title":"MONTH","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/month","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"VBYmoI98unLBA8GHFSQx","title":"DATE.NOW","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/now","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"2a3gIkLJaTFHcvBd2Xgp","title":"PERIOD_RANGE","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/period_range","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lvA0OuKtVw6WEcp8sNXB","title":"TO_EXCELDATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/toexceldate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8yot6HgUik49mFNCaWQJ","title":"YEAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/date-functions/year","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"uojh5KjZPJJ5LNHSxbfl","title":"Time intelligence functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"1C0FQdV4lT81XwOtP171","title":"AGGREGATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/aggregate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"getuJY0EcXytgilW7GAA","title":"FILTER","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/filter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"JQn5z0zutzIWUvNmjhgu","title":"COLUMN_PERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/column_period","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"iy6VcuxDD0yJqKgQO1B6","title":"LASTNDAY","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/lastnday","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"PBjEdEj1ACZgOojxelhU","title":"LASTNMONTH","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/lastnmonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"hqWXQxzY8iauxKiR08Ab","title":"LASTNQTR","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/lastnqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"VfOpP8Jr1AfcZCsbY7jd","title":"LASTNYEAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/lastnyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"A4xz0bZzWFCFPGkltkYF","title":"MONTHPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/monthperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"FfNPAKNyMCF1TD849F5x","title":"MOVINGAVERAGE","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/movingaverage","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"qv8QTFBHbaCj4WTkzyWD","title":"MOVINGSUM","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/movingsum","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"RF1iMJbqfCTXTicFiXRf","title":"MTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/mtd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"tH7hPOP9x14Sk89VzFet","title":"NEXTNDAY","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/nextnday","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"gcGe5aEdpUV6vlUwLfZG","title":"NEXTNMONTH","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/nextnmonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"zsQVHHCKmoXGfHBZUgSP","title":"NEXTNQTR","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/nextnqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"2NuyAp8GkpPQLvp7nA8z","title":"NEXTNYEAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/nextnyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"7s7ff9NZQCj4V7QnTtJ0","title":"QTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/qtd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"PtMFQZ1tKBJIoLxqdilT","title":"QTRPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/qtrperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"9g61ULb2G0uklceShu0Q","title":"SHIFT","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/shift","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"OpjFvBwN1RQG4Xo2IGff","title":"TOTALYTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/totalytd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"WvoUs6vZ5txZVaLlnG3K","title":"TOTALQTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/totalqtd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"nnXYHJnXfxMfAihPXnQw","title":"TOTALMTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/totalmtd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"JX1C8SFnCPG0JiHH8JP1","title":"VALUEAT","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/valueat","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"ZnMpVkVR4FNQ88kCZRYE","title":"YEARPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/yearperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"LYksOE8tIEu380optTv3","title":"YTD","pathname":"/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/ytd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"YG8TtafyR5w5jOKcECoL","title":"Other operators","pathname":"/documentation/plan/planning-sheets/formula-syntax/other-operators","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"MVJkdAbfiCCBPvcToOEd","title":"Identifiers","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"fhnhHWYX5qLq8zgulCO2","title":"CLOSEDPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/closedperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"lMSMyf1KTmmXN8UayiOv","title":"COLUMN.DATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/column.date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"1qnEiRLLKCGPtTWSD7K4","title":"COLUMN.PARENT","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/column.parent","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"GHpK0vzuKBFuxManFtPP","title":"COLUMNS","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"Bt0KWCKjTptCg2rkzwTW","title":"CURRENT_PERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/current_period","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"NQVO7ckd8XRG151qPDw1","title":"DESCENDANTS","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/descendants","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"BEW1Q4CefOJlqPcXttOh","title":"FORECAST.CLOSED_END","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/forecast.closed_end","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"aHQc1xNuFYunTxoB1Zpf","title":"FORECAST.CLOSED_START","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/forecast.closed_start","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"ByF0gSe23a3MsJkIczcI","title":"FORECAST.OPEN_END","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/forecast.open_end","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"mwKxAjDpzxdJE4TkKqkL","title":"FORECAST.OPEN_START","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/forecast.open_start","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"oVU5dCTOJIwBDSt2VjUF","title":"GROUP INDEX","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/group-index","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"8gC6NDHI1vO0pGfM9Jp1","title":"HAS","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/has","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"Ic74ErSDqvFiODfxIc6V","title":"HAS_ALL","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/has_all","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"dL01OJFx7TDRUVNU85lT","title":"HAS_SOME","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/has_some","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"eP7XntJrLX54gyI8eNn7","title":"LEAVES","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/leaves","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"80TGfHSAQLijwmeksJhN","title":"LEVEL","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/level","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"bGky82ujKbImFOUqb1SC","title":"LOGGEDIN_EMAIL","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/loggedin_email","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"wG9aQnyqWDpKf74MDKsz","title":"LOGGEDIN_NAME","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/loggedin_name","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"6toyCR7IFU1QHAlGqs5f","title":"MATCH","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/match","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"7bUi7XuIknPz7tgifBE6","title":"MAXDATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/maxdate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"PHCAYiG5jTEW3tWGtcIa","title":"MEMBERS","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/members","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"tI6pqXME67JYBUBdmprc","title":"MINDATE","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/mindate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"FnmB7oyaFYxp99t51QsW","title":"RELATIVE","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/relative","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"53lMUTKH9aPe80lLApT9","title":"RELATIVE_COLUMN","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/relative_column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"cKtOh2XD6oIFpXBiQerl","title":"ROW.PARENT","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/row.parent","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"YRLjoLdCC6Nu9SzVIVky","title":"ROW.LABEL","pathname":"/documentation/plan/planning-sheets/formula-syntax/identifiers/row.label","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"c8wML0XeCmptUsU3Aisg","title":"Scripting functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"LLDV5RBYGTrHpPHM0Khk","title":"DISPLAYTOAST","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/displaytoast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4GmnEVa5jx53JkCkLWJM","title":"EXPORT","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/export","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4aVL4ji6z5ezqORkKOpL","title":"LAYOUT","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"Uvn7UVDZCwYpXux7eNid","title":"OPENFILTER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openfilter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"zx5FdTu6Ft3jsPJI2yaj","title":"OPENKPIEXPLORER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openkpiexplorer","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"IYggoazsrSx7yLhuHJNy","title":"OPENMANAGECOLUMN","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openmanagecolumn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KkbsQMI89pCwJwy2Pi4Q","title":"OPENSEARCH","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/opensearch","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"WIyrK8hj0bD3vnDmpLcj","title":"OPENTOPN","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/opentopn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"pL2hKOtmZbtdOgwpo58D","title":"SENDMAIL","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/sendmail","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EBhDPDhxF8Q2jaQIK1r1","title":"SETCFRULE","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setcfrule","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BjzJwN1LySH4qIXvPahD","title":"SETCOLUMNSORT","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setcolumnsort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"UyqFjPmSRPZ30vDqdpDB","title":"SETFILTER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfilter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"n3DcyJZGOJTC57eTFvlw","title":"SETFILTERBYINDEX","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfilterbyindex","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EFJgsliL5VhlP0wSeSBE","title":"SETFONTSIZE","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfontsize","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"dPscm5R3D0lHhSPMZdP3","title":"SETFOOTER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfooter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"C9BFvHgLRBk04CN6JVc3","title":"SETHEADER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setheader","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"tPpqVONU7j0GHraFOBut","title":"SETLOCK","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setlock","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"oJDbB7oJT9OPgZyNTipm","title":"SETMEASURETITLE","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setmeasuretitle","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"VoH2cUmPDXdV5Nzg6NJg","title":"SETMAXDECIMALPRECISION","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setmaxdecimalprecision","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"poBtFcBhbxo3xFe3KdEp","title":"SETPAGINATION","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setpagination","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"nNlqWPq85ceLsq7oa5oV","title":"SETSCALING","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setscaling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"w50qN7scOF8utUfsr4Ot","title":"SETSEMANTICFORMATTING","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setsemanticformatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"neci4NTB6cGptXIWcfEO","title":"SETSTATUSBAR","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setstatusbar","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"mlC8yab6rUOvBCGFq80h","title":"SETVALUE","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setvalue","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BadWz6cZ3g2vkCHqWf37","title":"SETVISIBILITY","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setvisibility","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"Oe1ME4WmbWJJymMznXBW","title":"SHOWBETWEENPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showbetweenperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"ouwnYuvuaAKu50TsGkGm","title":"SHOWCLOSEDFORECAST","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showclosedforecast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KIfIYACONM1pShrL0sg7","title":"SHOWMEASUREBETWEENPERIOD","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showmeasurebetweenperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"42iAW4rINxgPxReb6P78","title":"TOPN","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/topn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"e7KJ9e2hU3eXiQQob8IV","title":"DISPLAY SETTINGS","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"0dHCqB6hdGvJqgBaW6QG","title":"SETBLANKLABEL","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setblanklabel","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"LHPp7khRgkfOeg6dzDay","title":"SETSUPPRESSZEROS","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setsuppresszeros","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"GE3RkOh1U6H7RKB9A5Yx","title":"SETRAGGEDHIERARCHY","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setraggedhierarchy","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"fyMZa1h0LmKfgwUuVY44","title":"SEPARATOR","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/separator","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"nadzc0BtlUKKyNI4vurt","title":"SETCOMBINECOLUMNHEADER","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"2f4FRNENJgyL64KOa6jB","title":"SEMANTICFORMAT","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/semanticformat","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"UGWrsro5DJyNHdoLhmRc","title":"SHOWNULLAS","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/shownullas","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"8nTjWaqDYswWJg3IlQIm","title":"SHOWZEROAS","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/showzeroas","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"v9N787dOqyh93Hjqv5rW","title":"SINGLECHILD","pathname":"/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/singlechild","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"VMXodINSF8idYNV272BN","title":"Statistical Functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions","siteSpaceId":"sitesp_ofx2Z","description":"Analyze data using statistical functions to summarize, measure variation, and uncover insights.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"y7fkj2k4xRQHt4p6bx6n","title":"Calculate measures of central tendency","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-measures-of-central-tendency","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"SjjIlgQYKJYWgutKzUTu","title":"RANKEQ","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"7ICWmNkyeymEjt830eS5","title":"RANKAVG","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"WvRcjOVk7Jh5tiy0TK17","title":"QUARTILEINC","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions/quartileinc","siteSpaceId":"sitesp_ofx2Z","description":"Calculate quartiles using the inclusive method to understand data distribution.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"Ch3ZVigqmVrsqA8bccXb","title":"QUARTILEEXC","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions/quartileexc","siteSpaceId":"sitesp_ofx2Z","description":"Calculate quartiles using the exclusive method to understand data distribution.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"OveKuRBVOaKB92MTbbxD","title":"VARS","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"IpSbre0SKrwNe6aIm9dp","title":"VARP","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"W21qsD497ACLgGnA4X7G","title":"STDEVS","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions/stdevs","siteSpaceId":"sitesp_ofx2Z","description":"Measures the sample standard deviation to analyze data variability.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"KbMZEO4t0r8qOYuKgVE3","title":"STDEVP","pathname":"/documentation/plan/planning-sheets/formula-syntax/statistical-functions/stdevp","siteSpaceId":"sitesp_ofx2Z","description":"Measures the population standard deviation to analyze data variability.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"UKNZeAam7UPWaPtcuT5g","title":"PERCENTILEINC","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"XO8lJ8u4CGEuX6wxZs6q","title":"PERCENTILEEXC","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"tzpescM0c7wblKpbanP8","title":"NORMDIST","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"kMpTiH6vUbn1O7eES1BR","title":"NORMSDIST","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"BbPFWbP1TdwRmxAj2ovB","title":"NORMINV","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"KrktcSbK0PhCcFzYLv5a","title":"NORMSINV","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"aJgYHRUidnCD0A6ccvqL","title":"PERCENTRANKINC","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"VOpJtfAHDXbHDm8bwuJj","title":"PERCENTRANKEXC","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"yuV75wmoqHiuaMfP6iTv","title":"Miscellaneous functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"tgd1osdxp2InLMYQhRy9","title":"FETCH","pathname":"/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions/fetch","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"GCJX3L5qUnEsWe8wJ1gr","title":"LOOKUP","pathname":"/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions/lookup","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"CvdjurcX9xjYHS1efSP8","title":"Measure/Column selection functions","pathname":"/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"}]},{"id":"fGIagCrV70fAp3IK67cG","title":"GETCOLBETWEENPERIODS","pathname":"/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/getcolbetweenperiods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"iZ4HfZZTZDkLABXd3YBG","title":"GETMEASURE","pathname":"/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/getmeasure","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"8SmH8nzTlk9Wkg3Ea3nB","title":"SELECT","pathname":"/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/select","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"WFhSO3nZhsxAgmxtk2XW","title":"SELECT_BYINDEX","pathname":"/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/select_byindex","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"VEjvb7Lk8il7fi70zm0G","title":"Troubleshoot","pathname":"/documentation/plan/planning-sheets/troubleshoot","siteSpaceId":"sitesp_ofx2Z","icon":"screwdriver-wrench","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Planning sheets"}]},{"id":"U7ZquazctbfqnFKPEUJt","title":"PowerTable sheets","pathname":"/documentation/plan/powertable-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"MO6cmajdVKtSZzriC5MC","title":"Concepts","pathname":"/documentation/plan/powertable-sheets/concepts","siteSpaceId":"sitesp_ofx2Z","icon":"calendar-check","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"}]},{"id":"YAsO2OY2vot4E0MjcLr7","title":"Relation column (Master-detail relationship)","pathname":"/documentation/plan/powertable-sheets/concepts/master-detail-tables-parent-child-linked-records","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"8GuUbMxvbsTexmXrM9e9","title":"Layouts","pathname":"/documentation/plan/powertable-sheets/concepts/layouts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"HPnpj4KWjZd1lnvX5pkg","title":"Gantt chart","pathname":"/documentation/plan/powertable-sheets/concepts/gantt-chart","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"ncITMs3U020JgxNP8msL","title":"Slowly changing dimensions","pathname":"/documentation/plan/powertable-sheets/concepts/type-2-scds","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"aMXgfTxfc79qqghkwtr9","title":"How-tos","pathname":"/documentation/plan/powertable-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"}]},{"id":"1TGQU17AOVTSvx7X2IIl","title":"Build a no-code table app with PowerTable","pathname":"/documentation/plan/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"c2IKHSV0LhbpY24wmfBY","title":"Connect PowerTable sheet to a semantic model","pathname":"/documentation/plan/powertable-sheets/how-tos/connect-powertable-sheet-to-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"tT80TQzsvkntHUi2WKy0","title":"Connect to a Database","pathname":"/documentation/plan/powertable-sheets/how-tos/connect-to-a-database","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"iBIMXtjC9x0v8EI0Dw3f","title":"Enter Data Manually","pathname":"/documentation/plan/powertable-sheets/how-tos/enter-data-manually","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"teWzpI7UxTaQmULq37Dw","title":"Data management","pathname":"/documentation/plan/powertable-sheets/how-tos/basic-table-operations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"9b9a91abafae7b92393ed7e92e2b16ea8d5825bf","title":"Edit and Bulk-edit data","pathname":"/documentation/plan/powertable-sheets/how-tos/basic-table-operations/edit-and-bulk-edit-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Data management"}]},{"id":"xsowk8f2TSywWLPJpIOe","title":"Preview Changes","pathname":"/documentation/plan/powertable-sheets/how-tos/basic-table-operations/preview-changes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Data management"}]},{"id":"a9179689701ae2bda3829d8a7596c17fabfdc62c","title":"Insert, import, duplicate, and delete rows","pathname":"/documentation/plan/powertable-sheets/how-tos/insert-import-duplicate-and-delete-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"8023aeee8209173d38ab88d9a11e5825a2f4bac6","title":"Add Columns - Overview","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"c575729f8aeca15ada3ad53d0ed2e53c55fed90b","title":"Add visual column overview","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"ae1c321761d999343109cb5f3851c8ff42311328","title":"Multi-select relationship column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"283c75c151dad9d0b96740c138ed9f39a137e9b0","title":"Reference Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"7a3299a7d6ef877f05982d116a793aa89abf55b6","title":"Relation Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/relation-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"Tf6eIkXCAnSeC9aMLje3","title":"Rollup column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"fa9406e8aad127728b03de1fb275c17fa67f8d06","title":"Button Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/button-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"9e53934a2f39e99256c3a0ccbfe00f0b20716cd2","title":"Attachment Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/attachments-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"},{"label":"Add visual column overview"}]},{"id":"7da2eb3f2b327dc0fadddfbcc2b92d2782c2d1e0","title":"Add Database Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-database-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"c11350c45d8894603daaf0839a8f0951851c83b4","title":"Add Formula Column","pathname":"/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-formula-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"d1f6cf9199e2de9083880ad48b48ec4e0a887553","title":"Configure column properties","pathname":"/documentation/plan/powertable-sheets/how-tos/configure-column-properties","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"43a382c2b2837292159d8423d6e01e66424cfa56","title":"General","pathname":"/documentation/plan/powertable-sheets/how-tos/configure-column-properties/general","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure column properties"}]},{"id":"ff5d993b3716c2851407fbc743a53ae5eb28c80e","title":"Display","pathname":"/documentation/plan/powertable-sheets/how-tos/configure-column-properties/display","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure column properties"}]},{"id":"80863bc933c5ae576c37853b781ef44bd7675bd4","title":"Lookup and relation","pathname":"/documentation/plan/powertable-sheets/how-tos/configure-column-properties/lookup-and-relation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure column properties"}]},{"id":"90XL7RDRQVxktYqNKFIi","title":"Set up row and column access control","pathname":"/documentation/plan/powertable-sheets/how-tos/set-up-row-and-column-access-control","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"5247964e6086f421316bb292a701da517fa31110","title":"Manage Columns","pathname":"/documentation/plan/powertable-sheets/how-tos/manage-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ebc1d58ec9b06b5b848b436216cdf620455df4d8","title":"Change column widths","pathname":"/documentation/plan/powertable-sheets/how-tos/manage-columns/change-column-widths","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage Columns"}]},{"id":"7f41d8d534868b21a74a65364179abf6add1e384","title":"Configure layouts","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"071719f5aba1b9c348821704e61fa2052add04a0","title":"Hierarchy layout","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/hierarchy-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"tMXF9iDKNQLsDnJDWqjs","title":"Crosstab","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/crosstab","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"decda3fe2c1e7b4bcb39435573e59321e296e408","title":"Gantt","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/gantt-chart-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"8118532677a619d6e9340551bce268149ebe98c7","title":"Resource","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/resource-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"Ubfx3itxnCnANCv1dC69","title":"Calendar layout","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/calendar-layout","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"5eMgeBHc2rzsL7N2ebQ2","title":"Kanban","pathname":"/documentation/plan/powertable-sheets/how-tos/layout-views-summary/kanban","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"NnmvdHyyKHJSf6fVtPh7","title":"Create data entry forms","pathname":"/documentation/plan/powertable-sheets/how-tos/generate-forms","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"QEYkFb5oxJWLQg5ACH5f","title":"Approval flow","pathname":"/documentation/plan/powertable-sheets/how-tos/approval-flow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"azKSmaWp8Z4BPdMdBIcU","title":"Configure approval workflow","pathname":"/documentation/plan/powertable-sheets/how-tos/approval-flow/configure-approval-workflow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"7DP9tAXqTqytlNCynmCZ","title":"Review changes in PowerTable approval workflow","pathname":"/documentation/plan/powertable-sheets/how-tos/approval-flow/review-changes-in-powertable-approval-workflow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"yPcwFjN1tsQXyIQXQJlX","title":"Automation","pathname":"/documentation/plan/powertable-sheets/how-tos/automation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"3Y0yYb29hDtFApWXlTdp","title":"Automation introduction","pathname":"/documentation/plan/powertable-sheets/how-tos/automation/automation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Automation"}]},{"id":"ZocxMXEjBpkmLpMq6t9Z","title":"Configure automation workflows","pathname":"/documentation/plan/powertable-sheets/how-tos/automation/configure-automation-workflows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Automation"}]},{"id":"FYKQLGqK4diSQQlxAymz","title":"Create a sample automation","pathname":"/documentation/plan/powertable-sheets/how-tos/automation/create-a-sample-automation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Automation"}]},{"id":"xGP6xgg94Jj1dcpZXROB","title":"Commenting and collaboration","pathname":"/documentation/plan/powertable-sheets/how-tos/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"TIAHE19sjZPe9RvVFvU6","title":"Export powertable sheet","pathname":"/documentation/plan/powertable-sheets/how-tos/export-powertable-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"FeqsyI3m8UlqLY8AyNVI","title":"Conditional Formatting","pathname":"/documentation/plan/powertable-sheets/how-tos/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"HC7jnJ4OStgvDFjwf7UO","title":"Audit log","pathname":"/documentation/plan/powertable-sheets/how-tos/audit-log","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"QkfnhNHSxz7B9au760Q3","title":"Create slowly changing dimensions","pathname":"/documentation/plan/powertable-sheets/how-tos/create-slowly-changing-dimensions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"uJJ8v6M4cq7y0uBZqDNa","title":"Explore and organize data","pathname":"/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"jpioTXGELb46XiZURv5V","title":"Filter data","pathname":"/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data/filter-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Explore and organize data"}]},{"id":"fbDA5HnzqdoMEoupvBTM","title":"Group rows","pathname":"/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data/group-rows","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Explore and organize data"}]},{"id":"GU9LcIP89dDv27kduX7a","title":"Appearance settings","pathname":"/documentation/plan/powertable-sheets/how-tos/appearance-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"3Y6QLnpZQzWESAcq1Bwx","title":"Reference","pathname":"/documentation/plan/powertable-sheets/reference","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"}]},{"id":"dc805c9ba2907eb323244357c3de7042c0040f0a","title":"Supported column and input types","pathname":"/documentation/plan/powertable-sheets/reference/supported-column-types","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Reference"}]},{"id":"oqHIlE5sBulvNAalwaWQ","title":"Supported file types for attachment","pathname":"/documentation/plan/powertable-sheets/reference/supported-file-types-for-attachment","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"PowerTable sheets"},{"label":"Reference"}]},{"id":"7lqE4ATHS0bLIEeSrFrX","title":"Intelligence sheets","pathname":"/documentation/plan/intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"iyINGCFbJ6iGmmK7zSAb","title":"How-tos","pathname":"/documentation/plan/intelligence-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"}]},{"id":"Le56AiOcpKpxNQoxDRxe","title":"Get started with Intelligence sheets","pathname":"/documentation/plan/intelligence-sheets/how-tos/get-started-with-intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"AucLZAq1IPlj5boxspU5","title":"Get started with reporting","pathname":"/documentation/plan/intelligence-sheets/how-tos/get-started-with-reporting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ahmVnWS0Dd5GaJOnIPHD","title":"Apply conditional formatting","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZJPmNKa5xg6k9jUFOjYN","title":"Showcase data points in charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/showcase-data-points-in-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"cgvjzLWX04Gn8dhIGhPP","title":"Highlight tabular data with conditional formatting","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/highlight-tabular-data-with-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"txnVsNgKPu71v2Yo9wls","title":"Create rules","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/create-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"SsibLLqx7GCpXlj9XkHn","title":"Build financial reports","pathname":"/documentation/plan/intelligence-sheets/how-tos/build-financial-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hZzZD6HvBNynva3tVI3u","title":"Collaborate on reports with comments","pathname":"/documentation/plan/intelligence-sheets/how-tos/collaborate-on-reports-with-comments","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"GmHllVsQoNnbrQ1s4kXB","title":"Pagination and formatting for reports","pathname":"/documentation/plan/intelligence-sheets/how-tos/pagination-and-formatting-for-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hlrllHW4TQfaK2fhqlj9","title":"Export high-quality PDF & Excel reports","pathname":"/documentation/plan/intelligence-sheets/how-tos/export-high-quality-pdf-and-excel-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"xD7g8p48pvAtcOdOjt0p","title":"Visualize simulations, budgets, and forecasts","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ECVJ25muQ9oGi5S1F7I3","title":"Monitor project progress with Gantt charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/plan-projects-with-gantt-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Im1Ut4RCY3J7o7p2TPyx","title":"Retain report data with Writeback","pathname":"/documentation/plan/intelligence-sheets/how-tos/retain-report-data-with-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hbu6vyGjJ5MI99chhmjx","title":"Build multi-measure charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/build-multi-measure-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"82NC1fKYnMWbQj4F0l7X","title":"Use themes for consistent color schemes","pathname":"/documentation/plan/intelligence-sheets/how-tos/use-themes-for-consistent-color-schemes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"4hM00zGijWU9r82TkkY4","title":"Ranking data","pathname":"/documentation/plan/intelligence-sheets/how-tos/ranking-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"6jGqLfKPCf7K2qtUaIAF","title":"Sorting data","pathname":"/documentation/plan/intelligence-sheets/how-tos/sorting-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"gyP45e9LgxShOCXxBflk","title":"Filter data","pathname":"/documentation/plan/intelligence-sheets/how-tos/filter-data","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"K5FkCjaSlHzf9qDLu2Ke","title":"Add date filters","pathname":"/documentation/plan/intelligence-sheets/how-tos/filter-data/add-date-filters","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"sAOF0RorswlZD7hbo9Mm","title":"Create a filter panel","pathname":"/documentation/plan/intelligence-sheets/how-tos/filter-data/create-a-filter-panel","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"LvC4EBBZT4U86C6rk6AA","title":"Add a treemap filter","pathname":"/documentation/plan/intelligence-sheets/how-tos/filter-data/add-a-treemap-filter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"w58LQGrchcdbhu8vTxWx","title":"Add a hierarchy filter","pathname":"/documentation/plan/intelligence-sheets/how-tos/filter-data/add-a-hierarchy-filter","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"NIqP42Tw6AoERFpnrkMx","title":"Build a dashboard","pathname":"/documentation/plan/intelligence-sheets/how-tos/build-a-dashboard","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Nq1rMVfQlxN2QwNkW74I","title":"Apply IBCS formats","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"nl2aDFd8sOFC4HNmgYu4","title":"Column and bar charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/column-and-bar-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"3sjDXjXXdXx0GF1Xd8fd","title":"Waterfall charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/waterfall-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"C2b2U8NretiXNWwj7dm7","title":"Area and line charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/area-and-line-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"mzCbtKXO17mQcZxTFh80","title":"Scatter and bubble charts","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/scatter-and-bubble-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"mBgoscUjGvdm4uuYhYgZ","title":"Small multiples","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/small-multiples","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"kaqFlwAlCHSyVo47PW0c","title":"Table templates","pathname":"/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/table-templates","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"oNN3tA2zAj3oKGYPeE0Z","title":"Visualization library","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"VsqEoapRdND7aqiY0VNP","title":"Sankey chart","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library/sankey-chart","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"1VevOLAUy8oetTr0FpMm","title":"Boxplot","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library/boxplot","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"tvuRXRaYHB6RahLwuSNl","title":"Multi axis chart","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library/multi-axis-chart","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"yTQHeYDbUOexHBbq5gsU","title":"Slope graph","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library/slope-graph","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"DAiibUsVcVzz0kXxUpm4","title":"Network graph","pathname":"/documentation/plan/intelligence-sheets/how-tos/visualization-library/network-graph","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"3EU1SS2BlD5MNS0WIyVZ","title":"Compare data with small multiples","pathname":"/documentation/plan/intelligence-sheets/compare-data-with-small-multiples","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Intelligence sheets"}]},{"id":"9btFGkfNsBdI76WrBF0E","title":"Infobridge","pathname":"/documentation/plan/infobridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"}]},{"id":"Fd6KsJOPN47EUOxc3ouE","title":"Concepts","pathname":"/documentation/plan/infobridge/concepts","siteSpaceId":"sitesp_ofx2Z","icon":"calendar-check","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"dK3NXJdvUtQxtykOlY7j","title":"Connected planning","pathname":"/documentation/plan/infobridge/concepts/connected-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"s4x1DfmxW0Y2LFl1pC37","title":"How-tos","pathname":"/documentation/plan/infobridge/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"SwliBW8cfMAgmOF5LQFJ","title":"Create a bridge to integrate and transform plans","pathname":"/documentation/plan/infobridge/how-tos/1.-create-bridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"u65ZysHGAjgprogpaO4j","title":"Consolidate data between sheets","pathname":"/documentation/plan/infobridge/how-tos/import-measures-between-planning-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Due8bZcgEc8DXe0Z7syN","title":"Import data into a bridge","pathname":"/documentation/plan/infobridge/how-tos/2.-add-source-to-bridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"N1eiwDxiZdnKEzto3NKk","title":"Manage query operations","pathname":"/documentation/plan/infobridge/how-tos/4.-manage-queries","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0TS4J0E33GNr4HbAEGk3","title":"Query transformations","pathname":"/documentation/plan/infobridge/how-tos/query-transformations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0J2TTBFDgV32nvKoVYJZ","title":"Append Queries","pathname":"/documentation/plan/infobridge/how-tos/query-transformations/append","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Query transformations"}]},{"id":"pj8VL7MKD6uygSzslN1y","title":"Join queries","pathname":"/documentation/plan/infobridge/how-tos/query-transformations/join","siteSpaceId":"sitesp_ofx2Z","description":"Explore how to leverage joins to retrieve data from multiple tables using a related column.","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Query transformations"}]},{"id":"wHTh7ao4ohJDVyKWncdF","title":"Duplicate","pathname":"/documentation/plan/infobridge/how-tos/query-transformations/duplicate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Query transformations"}]},{"id":"D04fG5CuRWDf2TK9QNbM","title":"Writeback transformed data from InfoBridge","pathname":"/documentation/plan/infobridge/how-tos/writeback-transformed-data-from-infobridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"AIzgJUwcprYcoeml0Ioj","title":"4. Manage sources","pathname":"/documentation/plan/infobridge/4.-manage-sources","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"KYeQc8xI7s7Jjgrtd1cu","title":"6. Insert measure from bridge","pathname":"/documentation/plan/infobridge/6.-insert-measure-from-bridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"srfLlm3pX35yn9JDglvM","title":"7. Manage Integration of Plan items","pathname":"/documentation/plan/infobridge/7.-manage-integration-of-visuals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"y9m7l68EiUJftNnNX0dJ","title":"8. Manage Bridges","pathname":"/documentation/plan/infobridge/8.-manage-bridges","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"AzpcSN8sE56mSHM47fUF","title":"9. Data transformations","pathname":"/documentation/plan/infobridge/9.-data-transformations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"J4bavjbHMVxbDFYtWlAy","title":"Pivot table","pathname":"/documentation/plan/infobridge/9.-data-transformations/pivot-table","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"CPDZdDHgwR7CblAEXH0G","title":"Group by","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"73iilL9z3zPsEWOKtLXK","title":"Add Column","pathname":"/documentation/plan/infobridge/9.-data-transformations/add-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"867ZKHK8aGH5iVSN5rZW","title":"Pivot column","pathname":"/documentation/plan/infobridge/9.-data-transformations/pivot-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"jcCJk0Hl3LnUaWwjXQrM","title":"Rename column","pathname":"/documentation/plan/infobridge/9.-data-transformations/rename-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"tzCCeKDTMQLz9I5zyAdP","title":"Find and Replace","pathname":"/documentation/plan/infobridge/9.-data-transformations/find-and-replace","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"jnD1KlvD2vo0iflysqZi","title":"Remove measure","pathname":"/documentation/plan/infobridge/9.-data-transformations/remove-measure","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"ro9I4AjYQz0PM0FCGwhR","title":"Filter rows","pathname":"/documentation/plan/infobridge/9.-data-transformations/filter-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"COXIDBv7XAuhHt5LMJgX","title":"Sort","pathname":"/documentation/plan/infobridge/9.-data-transformations/sort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"Ly6p3rDbZ27mvCMcbeoM","title":"Text functions","pathname":"/documentation/plan/infobridge/9.-data-transformations/text-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"qpCn2vy5qKHr4EkTMBGB","title":"Unnest","pathname":"/documentation/plan/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":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"7keiq1ADO3o6VidDobgp","title":"Round","pathname":"/documentation/plan/infobridge/9.-data-transformations/round","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"FOIZm9oj58hUm8ASGkNP","title":"Extract Comments","pathname":"/documentation/plan/infobridge/9.-data-transformations/extract-comments","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"woCB0ecyr7qlomX7AsQB","title":"Import and export","pathname":"/documentation/plan/infobridge/9.-data-transformations/import-and-export","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"},{"label":"9. Data transformations"}]},{"id":"SrTYNUKRUtIQFREqCCyj","title":"10. Integrating forecasts","pathname":"/documentation/plan/infobridge/10.-integrating-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"gchWDZWsm99uxZCuLwOh","title":"11. Collaborative adjustments","pathname":"/documentation/plan/infobridge/11.-collaborative-adjustments","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"2jqs5GNkNpVvjhnQKyP4","title":"Infobridge sheets in Plan (preview)","pathname":"/documentation/plan/infobridge/infobridge-sheets-in-plan-preview","siteSpaceId":"sitesp_ofx2Z","icon":"layer-plus","description":"","breadcrumbs":[{"label":"Documentation","icon":"dochub"},{"label":"Plan","icon":"bullseye-arrow"},{"label":"Infobridge"}]},{"id":"c1irKTto5xFPSeFc1p0m","title":"1 - Introduction to Plan (preview)","pathname":"/user-guide/1-introduction","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"yGQRczJRLFhjUMipH0Pi","title":"2 - Prerequisites and Data setup","pathname":"/user-guide/2-prerequisites-and-data-setup","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"A79vIFg6Nb3zQ6C6tu0m","title":"3 - Create your first plan app","pathname":"/user-guide/3-create-your-first-planning-app","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"fE3PsQbepphsPbiwGve2","title":"3.1 - Create a planning app","pathname":"/user-guide/3-create-your-first-planning-app/3-1-create-plan-app-connect-to-semantic-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"3 - Create your first plan app"}]},{"id":"dle3gtpPZgiz4IJGYBQ0","title":"3.2 - Explore the plan interface","pathname":"/user-guide/3-create-your-first-planning-app/3-2-explore-plan-interface","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"3 - Create your first plan app"}]},{"id":"J3RWjYm0uHKpGr6cX7VT","title":"3.3 - Basic interactions","pathname":"/user-guide/3-create-your-first-planning-app/3-3-basic-interactions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"3 - Create your first plan app"}]},{"id":"DQqtqr0y5YmgbNvvPrvs","title":"3.4 - Create a forecast","pathname":"/user-guide/3-create-your-first-planning-app/3-4-create-a-forecast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"3 - Create your first plan app"}]},{"id":"yZdTiEVgIVIS5CRFGrJy","title":"3.5 - Writeback and save data","pathname":"/user-guide/3-create-your-first-planning-app/3-5-writeback-and-save-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"3 - Create your first plan app"}]},{"id":"ur4irEb1T0ITshxd8JTx","title":"4 - Enter plans and budgets","pathname":"/user-guide/4-enter-plans-and-budgets","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"dWYJwHd021HxWJ6KeYQl","title":"4.1 - Configure data input","pathname":"/user-guide/4-enter-plans-and-budgets/4-1-configure-data-input-and-formulas","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"5ZObwDfIxxZwIOmI4HO2","title":"4.2 - Create plans with formulas","pathname":"/user-guide/4-enter-plans-and-budgets/4.2-create-plans-with-formulas","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"Mu1rIhxc9Hr2JgkCIEqv","title":"4.3 - Incremental and zero-based budgeting using number columns","pathname":"/user-guide/4-enter-plans-and-budgets/4.3-incremental-and-zero-based-budgeting-using-number-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"SHgRWYa1eVlhTwThBGg6","title":"4.4 - Insert budget approval status","pathname":"/user-guide/4-enter-plans-and-budgets/4-2-insert-budget-approval-status","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"exVspoXXo4hau5Jvt5Ks","title":"4.5 - Create a checkbox column","pathname":"/user-guide/4-enter-plans-and-budgets/4.5-create-a-checkbox-column","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"yyJBcvxDU87ntUxEq10a","title":"4.6 - Configure approver assignments using person columns","pathname":"/user-guide/4-enter-plans-and-budgets/4.6-configure-approver-assignments-using-person-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"rmkKkhulhNIcG4h3GOMQ","title":"4.7 - Configure approval deadlines using date columns","pathname":"/user-guide/4-enter-plans-and-budgets/4.7-configure-approval-deadlines-using-date-columns","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"vsQZI0ED7q57xkGYusCt","title":"4.8 - Summary: When to use what","pathname":"/user-guide/4-enter-plans-and-budgets/4-3-summary-when-to-use-what","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"4 - Enter plans and budgets"}]},{"id":"GqEek5mD3oD4JsgbByxQ","title":"5 - Top-down allocation","pathname":"/user-guide/5-top-down-allocation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"ZsWbdtZAx6F2FvC0itLM","title":"5.1 - Equal, weighted, or trend-based distribution","pathname":"/user-guide/5-top-down-allocation/5-1-allocate-values","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"5 - Top-down allocation"}]},{"id":"j7y6wSDKfaMhUwxP3aFs","title":"5.2 - Set minimum and maximum bounds","pathname":"/user-guide/5-top-down-allocation/5-2-set-minimum-maximum-bounds","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"5 - Top-down allocation"}]},{"id":"nFMzlOceWs2QAhtbvshH","title":"5.3 - Locking rules","pathname":"/user-guide/5-top-down-allocation/5-3-locking-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"5 - Top-down allocation"}]},{"id":"RYpV4Ni9tVEkr3Ii5JGS","title":"5.4 - Multi-dimensional allocations","pathname":"/user-guide/5-top-down-allocation/5-4-multi-dimensional-allocations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"5 - Top-down allocation"}]},{"id":"8rLMl6idAVfGfUmcAuXa","title":"6 - Forecasts","pathname":"/user-guide/6-forecasts-rolling-forecasts-and-statistical-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"a14S4svPTbpbTSATU4Av","title":"6.1 - Create forecasts using different methods","pathname":"/user-guide/6-forecasts-rolling-forecasts-and-statistical-forecasts/6-1-create-forecasts-using-formulas-existing-measures-or-data-input","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"6 - Forecasts"}]},{"id":"k4NfmjPXysKDeRYe1qz0","title":"6.2 - Reforecasting","pathname":"/user-guide/6-forecasts-rolling-forecasts-and-statistical-forecasts/6-2-reforecasting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"6 - Forecasts"}]},{"id":"rTJATwUVxdfqGhDPUmZu","title":"6.3 - Rolling forecasts","pathname":"/user-guide/6-forecasts-rolling-forecasts-and-statistical-forecasts/6-3-rolling-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"6 - Forecasts"}]},{"id":"2ntCj5mgjsFxaNiLKjVy","title":"6.4 - Statistical forecasts","pathname":"/user-guide/6-forecasts-rolling-forecasts-and-statistical-forecasts/6-4-statistical-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"6 - Forecasts"}]},{"id":"MojDmhL25GpcnC7EMWcy","title":"7 - What-if simulations","pathname":"/user-guide/7-what-if-simulations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"Kv5SsLSwTqmtkHefG8bh","title":"7.1 - Add a simulation measure","pathname":"/user-guide/7-what-if-simulations/7-1-add-a-simulation-measure","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"7 - What-if simulations"}]},{"id":"L4KnqDexnpzs9zgZoUzV","title":"7.2 - Bi-directional simulations","pathname":"/user-guide/7-what-if-simulations/7-2-bi-directional-simulations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"7 - What-if simulations"}]},{"id":"2yM8eccjfdiEZqyJrB61","title":"8 - Optimization in planning","pathname":"/user-guide/8-optimization-in-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"Cm7oOaaDg47OiX2Wb784","title":"8.1 - Target-based optimization","pathname":"/user-guide/8-optimization-in-planning/8.1-target-based-optimization","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"8 - Optimization in planning"}]},{"id":"yxqaO7nyiHISCTkTzgTr","title":"8.2 - Direction-based optimization","pathname":"/user-guide/8-optimization-in-planning/8.2-direction-based-optimization","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"8 - Optimization in planning"}]},{"id":"296h56NOkaYYNfBrTLxM","title":"9 - Scenario Planning","pathname":"/user-guide/9-scenario-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"eJADMTYvE8NkZGTXzJ6N","title":"9.1 - Create and configure a scenario","pathname":"/user-guide/9-scenario-planning/9.1-create-and-configure-a-scenario","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"9 - Scenario Planning"}]},{"id":"QRoS4ergXKcCgvdxqbLG","title":"9.2 - Bidirectional simulations in Scenarios","pathname":"/user-guide/9-scenario-planning/9-2-bidirectional-simulations-bulk-edit","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"9 - Scenario Planning"}]},{"id":"qcX8V5iBNsxtWHbE5D77","title":"9.3 - Compare scenarios","pathname":"/user-guide/9-scenario-planning/9-3-compare-scenarios","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"9 - Scenario Planning"}]},{"id":"QdImuxxa0fW0qeYAiVkt","title":"9.4 - Scenarios in tree layout","pathname":"/user-guide/9-scenario-planning/9-4-scenarios-in-tree-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"9 - Scenario Planning"}]},{"id":"bZTbtleK3V0QzDEMOwuR","title":"10 - Writeback","pathname":"/user-guide/10-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"}]},{"id":"RyWNnnQ1iteeNyMOSnw3","title":"10.1 - Core Writeback Capabilities","pathname":"/user-guide/10-writeback/10-1-writeback-capabilities","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"10 - Writeback"}]},{"id":"RB2XDGwh5Nmi86BihPuU","title":"10.2 - Configure writeback destination","pathname":"/user-guide/10-writeback/10-2-configure-writeback-destination","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"10 - Writeback"}]},{"id":"l2FYSkH9pfqYDtY800YW","title":"10.3 - Configure writeback settings","pathname":"/user-guide/10-writeback/10-3-configure-writeback-settings","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"10 - Writeback"}]},{"id":"CpsaFSqHtrpOWApJvKAs","title":"10.4 - Security and permissions","pathname":"/user-guide/10-writeback/10-4-security-and-permissions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"10 - Writeback"}]},{"id":"wnBedoa8RnY8CFYY4vOn","title":"Fabric Planning","pathname":"/video/fabric-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"}]},{"id":"5XeM0ZB7gqVAhuOOR9sB","title":"Fabric Planning Onboarding - Access and Setup","pathname":"/video/fabric-planning/fabric-planning-onboarding-access-and-setup","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Planning"}]},{"id":"YZ6mf0BTbVphzRIBHqIz","title":"Fabric Planning Overview #1","pathname":"/video/fabric-planning/fabric-planning-overview-1","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Planning"}]},{"id":"llMu9elrDf23AYeMxfgS","title":"Fabric Plan - Intelligence Sheet","pathname":"/video/fabric-plan-intelligence-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"}]},{"id":"m5HORDqtkRRPhqsMADHk","title":"Intelligence 301 - Fundamentals","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-301-fundamentals","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"rw0uwXi96RgauGixcYkN","title":"Intelligence 302 - Reporting","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-302-reporting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"cpYFKnmW58jhhAsmTUjT","title":"Intelligence 303 - Advanced Formatting","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-303-advanced-formatting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"skr6dlBrF2wBmJ1kqG7r","title":"Intelligence 304 - Planning Integration","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-304-planning-integration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"ZvB8UvtvzpMJLqLNYYqt","title":"Intelligence 305 - Power Table Integration","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-305-power-table-integration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"SKGb5co1NNdHA2jYexU7","title":"Bookmarks in Intelligence","pathname":"/video/fabric-plan-intelligence-sheet/bookmarks-in-intelligence","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"RBW1uiHdocQ5HqszIM8R","title":"Paginated Reports","pathname":"/video/fabric-plan-intelligence-sheet/paginated-reports","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"lZGZhMVB8ssOt5AHhe7w","title":"Fully Formatted Exports to Excel & PDF","pathname":"/video/fabric-plan-intelligence-sheet/fully-formatted-exports-to-excel-and-pdf","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"zsnLwd8zB1iKpHGa8wVd","title":"Financial Reporting","pathname":"/video/fabric-plan-intelligence-sheet/financial-reporting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"QinKEuLj2ZL2Ub59iQX4","title":"Performance Reporting and Variance Analysis","pathname":"/video/fabric-plan-intelligence-sheet/performance-reporting-and-variance-analysis","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"bCam66lFowmCIrBGb3yq","title":"Multi Trellis Variance Analysis","pathname":"/video/fabric-plan-intelligence-sheet/multi-trellis-variance-analysis","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"XzlZoxlszXPgcy2yduig","title":"Multi Level Financial KPI Cards","pathname":"/video/fabric-plan-intelligence-sheet/multi-level-financial-kpi-cards","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"MAqjSqgyAt90PyUFXNub","title":"Retail Performance Dashboard","pathname":"/video/fabric-plan-intelligence-sheet/retail-performance-dashboard","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"ag1ZiPJGj8YWm9l2Rrmz","title":"Customer Journey Analysis with Sankay Chart","pathname":"/video/fabric-plan-intelligence-sheet/customer-journey-analysis-with-sankay-chart","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"f24hGKagEHkc8RsNixD8","title":"Project Management Dashboard","pathname":"/video/fabric-plan-intelligence-sheet/project-management-dashboard","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"0CiQscZMloBQZA72yyzt","title":"Part 1 : Building a Live Cash Flow Forecast","pathname":"/video/fabric-plan-intelligence-sheet/part-1-building-a-live-cash-flow-forecast","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"LV8tnFB1yDXE2OkPibYQ","title":"Part 2: Cash Flow Planning & Scenario Simulation","pathname":"/video/fabric-plan-intelligence-sheet/part-2-cash-flow-planning-and-scenario-simulation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"ibDXXWOWj7APqmYRFzR0","title":"Commenting and Collaboration","pathname":"/video/fabric-plan-intelligence-sheet/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"tdefqVwLucXa9txvO95U","title":"Dashboard in Fabric Planning with 100+ Charts","pathname":"/video/fabric-plan-intelligence-sheet/dashboard-in-fabric-planning-with-100+-charts","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"FidjPD10YXP5DxY9gVm0","title":"IBCS Standardized Reports & Visualizations","pathname":"/video/fabric-plan-intelligence-sheet/ibcs-standardized-reports-and-visualizations","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"kNTTVW8cTIxz50YMyStQ","title":"Build Dashboards with KPI Cards","pathname":"/video/fabric-plan-intelligence-sheet/build-dashboards-with-kpi-cards","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"SfS1lZdnKYEBYCuKq0I9","title":"Ad-hoc Analysis and Data Exploration","pathname":"/video/fabric-plan-intelligence-sheet/ad-hoc-analysis-and-data-exploration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"GsfOZxBk6nhQIPtlovu3","title":"Build a KPI Card","pathname":"/video/fabric-plan-intelligence-sheet/build-a-kpi-card","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"tefQUyN24zA2mZ2ur96r","title":"Parameters in Fabric Plan","pathname":"/video/fabric-plan-intelligence-sheet/parameters-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"hGA0onlKasN6L5TrumsQ","title":"Box Plot on Power BI Semantic Model","pathname":"/video/fabric-plan-intelligence-sheet/box-plot-on-power-bi-semantic-model","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"ymMe9dhDXrTjPXkRnZC7","title":"Intelligence - Insert and Manage Rows in Microsoft Fabric Planning","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-insert-and-manage-rows-in-microsoft-fabric-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"wxHDZMzMUR3A2NEYC8So","title":"Intelligence - Insert and Manage Columns in Microsoft Fabric Planning","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-insert-and-manage-columns-in-microsoft-fabric-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"l7dOnlZk6T2X3kqg0njw","title":"FAQ","pathname":"/resources/faq","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"RwkMI5mNfiSurdbaeWs2","title":"PowerTable error codes and resolutions","pathname":"/resources/powertable-error-codes-and-resolutions","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"Uk2qlWzrJeNx3L32E85U","title":"Billing in Fabric Plan","pathname":"/resources/billing-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"4QrbLLlk4YIuoUUqWU3a","title":"Best practices","pathname":"/resources/best-practices","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"VK0q06s3b9eopLcWmXym","title":"Format dates for automatic time intelligence","pathname":"/resources/best-practices/format-dates-for-automatic-time-intelligence","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"},{"label":"Best practices"}]}]}