{"version":1,"pages":[{"id":"BBTZeYvQWU9RGIom3RaA","title":"What Is Planning in Fabric?","pathname":"/","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Overview"}]},{"id":"ViGtabWWFxmDmkz3AZFD","title":"Planning sheets in Planning","pathname":"/overview/planning-sheets-in-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Overview"}]},{"id":"s2ZqgUOM2BOqAFAR9eSk","title":"PowerTable sheets in Planning","pathname":"/overview/powertable-sheets-in-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Overview"}]},{"id":"156rULFLquSYWR1tZgc0","title":"Intelligence sheets in Planning","pathname":"/overview/intelligence-sheets-in-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Overview"}]},{"id":"44YclJMUf8NEhZTklE5N","title":"Infobridge - Connected Planning","pathname":"/overview/infobridge-connected-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Overview"}]},{"id":"PXezE5IvmbAaIQwRy7Uu","title":"0 - Introduction to Fabric planning","pathname":"/planning-tutorials/1-introduction-to-fabric-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"OyJswBs0EO9v7mCaOwuY","title":"1 - Allocations and collaboration","pathname":"/planning-tutorials/2-allocations-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"gABBLRS5g9r9kBgt6yVl","title":"2 - Optimize input values","pathname":"/planning-tutorials/3-optimize-input-values","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"GX0ZBovQyptdJTv0dGM8","title":"3 - Create a rolling forecast","pathname":"/planning-tutorials/4-create-a-rolling-forecast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"GMHMhKX5RLvKvEHVOhRX","title":"4 - Build a P&L hierarchy with Measure Model","pathname":"/planning-tutorials/5-build-a-p-and-l-hierarchy-with-measure-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"LyEfteY1wnOpYy8emdCS","title":"5 - Build a P&L hierarchy with Row Model","pathname":"/planning-tutorials/6-build-a-p-and-l-hierarchy-with-row-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"sgF76HUEVyno8yDrATbu","title":"6 - Consolidate plans across dimensions using cubes","pathname":"/planning-tutorials/7-consolidate-plans-across-dimensions-using-cubes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"MPqvF9wiuMxpPV1ecEjo","title":"9 - Introduction to intelligence sheets","pathname":"/planning-tutorials/9-introduction-to-intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"l31OaIC47WkOSUVUlDKg","title":"10 - Build a P&L intelligence sheet","pathname":"/planning-tutorials/10-build-a-p-and-l-intelligence-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"JbYLm1CZfXxpgSESbsx2","title":"11 - Create a planning sheet, PowerTable, and canvas integration","pathname":"/planning-tutorials/11-create-a-planning-sheet-powertable-and-canvas-integration","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"PLANNING TUTORIALS"}]},{"id":"9yYd0FWypUtpO1W0LNuN","title":"Prerequisites for Fabric Planning","pathname":"/get-started/prerequisites-for-fabric-planning","siteSpaceId":"sitesp_ofx2Z","description":"Configure tenant settings, capacity settings, and permissions for planning.","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"cdI66wSzhRixH7PvQYSJ","title":"Create and share a cloud connection for a semantic model","pathname":"/get-started/create-and-share-a-cloud-connection-for-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"hjgalITOm5gNjp3btmJ7","title":"Create a database connection for collaboration","pathname":"/get-started/create-a-database-connection-for-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"32udHuAAnrjaoP9YGb2K","title":"Create a planning sheet","pathname":"/get-started/creating-a-planning-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"1TGQU17AOVTSvx7X2IIl","title":"Get started with PowerTable sheets","pathname":"/get-started/create-a-table-app-with-powertable-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"ti62PaNHd17HfQyd2tj8","title":"Get Started with Intelligence sheets","pathname":"/get-started/get-started-with-intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"M8pif7RKfISQPoL2Jb7v","title":"Get started with reporting visuals","pathname":"/get-started/get-started-with-reporting-visuals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"GET STARTED"}]},{"id":"PBLXVykHutcb9mbM6PGn","title":"Concepts","pathname":"/planning-sheets/concepts","siteSpaceId":"sitesp_ofx2Z","icon":"calendar-check","description":"","breadcrumbs":[{"label":"Planning Sheets"}]},{"id":"G6H3ZpiZJ4SrSs1OSaKI","title":"Measure and row-based planning","pathname":"/planning-sheets/concepts/measure-and-row-based-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"CBxXlko1ZRV06e5Wdor2","title":"Measure Model - the semantic enrichment framework","pathname":"/planning-sheets/concepts/measure-and-row-based-planning/measure-model-the-semantic-enrichment-framework","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Measure and row-based planning"}]},{"id":"NYncJN2ZRQKjGUaLNolC","title":"Row model - the agile driver framework","pathname":"/planning-sheets/concepts/measure-and-row-based-planning/row-model-the-agile-driver-framework","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Measure and row-based planning"}]},{"id":"HoMzr5CZ2itPMqivoLi8","title":"Cube - Multidimensional planning","pathname":"/planning-sheets/concepts/measure-and-row-based-planning/cube","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Measure and row-based planning"}]},{"id":"QbOa9oB0fYwFbSmB2Jqh","title":"Planning tools","pathname":"/planning-sheets/concepts/planning-tools","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"ycTJE5BR6RThArNvH4z0","title":"Allocation rules and data input controls in planning sheet","pathname":"/planning-sheets/concepts/planning-tools/allocation-rules-and-data-input-controls-in-planning-sheet","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Planning tools"}]},{"id":"pWvttwBtA7uRSfrXqwWc","title":"Approval workflow","pathname":"/planning-sheets/concepts/planning-tools/approval-workflow","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Planning tools"}]},{"id":"GbUh62DUQOyJsSj64nrt","title":"Scenario planning","pathname":"/planning-sheets/concepts/planning-tools/scenario-planning-in-microsoft-fabric","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Planning tools"}]},{"id":"p3gidKQMkSLeeItciE2F","title":"Forecasting","pathname":"/planning-sheets/concepts/forecasting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"fWETHYpHgSw65lHXv0IE","title":"Statistical forecasting algorithms using Predict","pathname":"/planning-sheets/concepts/forecasting/predict-statistical-forecasting-algorithm","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Forecasting"}]},{"id":"AzBmewKAIvEOuXonID9e","title":"Reforecasting","pathname":"/planning-sheets/concepts/forecasting/reforecasting","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Forecasting"}]},{"id":"yE5FvREtXdPlvvmtVJ8z","title":"Closing forecast period","pathname":"/planning-sheets/concepts/forecasting/closing-forecast-period","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Forecasting"}]},{"id":"EmVpOGuOmC3In49Z6efT","title":"Collaboration and export - Writeback","pathname":"/planning-sheets/concepts/writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"BGmek0pN58K8cW2ZRkVb","title":"Connected Planning","pathname":"/planning-sheets/concepts/connected-planning","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"dK3NXJdvUtQxtykOlY7j","title":"Connected planning with Infobridge in Fabric Planning","pathname":"/planning-sheets/concepts/connected-planning/connected-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Connected Planning"}]},{"id":"X2iOZHxhW0MeGT3LgzTu","title":"Blend measures","pathname":"/planning-sheets/concepts/connected-planning/blend-measures","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"Connected Planning"}]},{"id":"DumsJCP0OWGERtloIAtN","title":"General","pathname":"/planning-sheets/concepts/general","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"htJB45YC63Nfs1vnUAvo","title":"Top-down Planning","pathname":"/planning-sheets/concepts/general/concepts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"General"}]},{"id":"6zSMWdXoSwLqQK8cy4mr","title":"Bottom-up Planning","pathname":"/planning-sheets/concepts/general/bottom-up-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Concepts","icon":"calendar-check"},{"label":"General"}]},{"id":"hQuoBmOCAhyVsgMsvmLC","title":"How-tos","pathname":"/planning-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"Planning Sheets"}]},{"id":"RswelvHQxEBjPAKxVGry","title":"Measure and row-based planning","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"lJKvzuF7vHqgAxSIHXkl","title":"Insert data input columns","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"}]},{"id":"UsNzHpiJpKzJECLUkpf3","title":"Insert column - Fundamentals","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-fundamentals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"d1U162wTDoFssKWgWuRI","title":"Insert column - Number","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-manual-input-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"m6YJeyIaNQ1IDxqgRFYV","title":"Insert column - Text","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/text-checkbox-and-date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"6yfrxTiMNqx5xzUTbYNg","title":"Insert column - Checkbox","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-checkbox","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"gsseNJII7Ejev5TjHEvc","title":"Insert column - Person","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/writeback-matrix-features","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"3nvoF8bszv5lxkBK5ZEC","title":"Insert column - List","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/dropdown","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"oI3IYWmyI8ineSrkZT1N","title":"Insert column - Date","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"1QRk9xoEQXY361kN9gIV","title":"Insert column - Formula","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-calculated-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"nlBWTrLLggOvT21bhuMP","title":"Insert column - Simulation","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-simulation","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input columns"}]},{"id":"aImJZ00e4aDW0TQJRJ64","title":"Measure-based modeling","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/measure-based-modelling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"}]},{"id":"dcx7doaSgUE838aWKJp7","title":"Cubes","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"}]},{"id":"ojfVbC8weTCSyrmD2svw","title":"Plan across multiple dimensions with cubes","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/allocate-values-across-dimensions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Cubes"}]},{"id":"zbAKvfJDrZlygL4wSBZO","title":"Multidimensional expense allocation","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-expense-allocation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Cubes"}]},{"id":"7lrvWz5bCSBfzvt4ZkUl","title":"Multidimensional forecasting","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-forecasting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Cubes"}]},{"id":"BlRrnkRO9eWL5XN4oUy4","title":"Cube best practices and FAQs","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/cube-best-practices-and-faqs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Cubes"}]},{"id":"qlmMl8c8ONp1123GRzUR","title":"Manage cube measures","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/manage-cube-measures","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Cubes"}]},{"id":"uZWWkdI8Mv8u79Zim6Bo","title":"Insert data input rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"}]},{"id":"jSIgD4V7zFEb7piAT7XT","title":"Insert rows - Fundamentals","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-manual-input-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"scV8vUppjZTho20bqdmC","title":"Insert template rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/template-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"LKop9ZyaVJubQf3gshCj","title":"Insert formula rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-calculated-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"gxazJQpGQs6lmYyUO1WW","title":"Insert blank rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-blank-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"AIvCvRvyYsV4oY5sGC4H","title":"Insert forecast rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-forecast-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"ZcrSbaWuo8gTHQBXoVvZ","title":"Manage inserted rows","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/rows/manage-inserted-rows-and-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Insert data input rows"}]},{"id":"2QEoe2MINod7ZZEts2s1","title":"Row-based modeling","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"}]},{"id":"vvScUhhn8il1BAdJQhHR","title":"Create a row model","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-a-row-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"MdVdYlPAcFuZC17zhOr8","title":"Create forecasts using row model","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-forecasts-using-row-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"jFEIwQ25jV2GEAxlg7PL","title":"Perform scenario analysis in row model","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/perform-scenario-analysis-in-row-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"xfiMOgyqnLoMBuvoTxlN","title":"Configure row properties in a row model","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/configure-row-properties-in-the-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"0ODTeMsLrVn037bb0q6D","title":"Create row model templates","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-templates-for-reusable-row-structures","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"Q1HWbQ9Q5w1WySW0P4Gd","title":"Tree view","pathname":"/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/tree-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Measure and row-based planning"},{"label":"Row-based modeling"}]},{"id":"C3eNamsIHNBzkFaH2sS6","title":"Forecast data to predict future trends","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"XdombW4kCoV8keBNzwRk","title":"Create a P&L forecast","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-a-p-and-l-forecast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"56ZdqBvao2mImGLgoziF","title":"Create multi-dimensional forecasts","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"Q99ASWXN01SpgGbXXIZY","title":"Manage rolling forecasts","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"enG17VIVLgDrBqarBz2x","title":"Generate Statistical Forecasts using PREDICT feature","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"lVABeURDpuO7AZw9OsMR","title":"Edit forecast settings","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"HniHNJWrX8BFWDGuQ1Km","title":"Forecasting FAQ","pathname":"/planning-sheets/how-tos/forecast-data-to-predict-future-trends/forecasting-faq","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Forecast data to predict future trends"}]},{"id":"k6r0xgT7wdtKkEO1CYsw","title":"Collabration and export","pathname":"/planning-sheets/how-tos/collabration-and-export","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"reUhWMJReoPJx3nMOebV","title":"Commenting and collaboration","pathname":"/planning-sheets/how-tos/collabration-and-export/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"}]},{"id":"ogdxreRx6iCfHv6dV18I","title":"Export data","pathname":"/planning-sheets/how-tos/collabration-and-export/exports-in-the-planning-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"}]},{"id":"FjnLgf3NSz36MS9nYheM","title":"Persist data with Writeback","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"}]},{"id":"LBWy9L9l6V46sFmatyuV","title":"Writeback in Plan","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/writeback-in-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"ZBLm8CHg8M8z77AiVqqz","title":"General Settings","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/general-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"KdigUkMbNEWZ0ON80azs","title":"Data Settings","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/data-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"Zwuzsh1Id7CpkQ4dHAtx","title":"Destination Settings","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/destination-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"5kLqldRHvClIYmRWO6C4","title":"Configure advanced settings","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-advanced-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"LECa1REKl1ZFEcFdLvXo","title":"Configure writeback destinations","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-writeback-destinations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"4SdrxPiQ52gYjlEteuU7","title":"View Logs","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/view-logs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"UARhSdHLBI4rGMK6Ake1","title":"Enable writeback in reading mode","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/enable-writeback-in-reading-mode","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"7qlFuQ6aPHy2URrEJuWh","title":"FAQs on Writeback","pathname":"/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/faqs-on-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Collabration and export"},{"label":"Persist data with Writeback"}]},{"id":"1n70ugrLLDOPJM1ttzWl","title":"Analyze planning outcomes with scenarios","pathname":"/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ljF8Vd8hRu34ByjfZDHt","title":"Pivot data","pathname":"/planning-sheets/how-tos/pivot","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"cf4iDMzTtr4M33wGpBSS","title":"Format and display","pathname":"/planning-sheets/how-tos/format-and-display","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"wkUDlmQTLrz6mBXv8FNM","title":"Layouts","pathname":"/planning-sheets/how-tos/format-and-display/layouts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"}]},{"id":"NJKIjeK5xkYfXFeJnoCI","title":"Conditional formatting","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"}]},{"id":"blr1sXqrk99n458u3l7r","title":"Create rules in Conditional Formatting","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"}]},{"id":"TLJLKSaQ412kvGUi6tUJ","title":"Format by Rules (If conditions) in conditional formatting","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"ysKUmvvAM1A7PE1MDoKF","title":"Format by Color scale conditional formatting","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"QRxTHh7Xydnk9EGS7hhb","title":"Format by classification conditional formatting","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"},{"label":"Create rules in Conditional Formatting"}]},{"id":"luE2mAltuHVcCvqalzIa","title":"Quick formatting options","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/quick-formatting-options","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"}]},{"id":"4VWIF6r8UVi3Fr8WETny","title":"Manage Rules","pathname":"/planning-sheets/how-tos/format-and-display/conditional-formatting/manage-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"},{"label":"Conditional formatting"}]},{"id":"nao19jxgUlvWKmZe4Dws","title":"Add notes in a planning sheet","pathname":"/planning-sheets/how-tos/format-and-display/notes-in-commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Format and display"}]},{"id":"2IGnqW2o1Vcnn3kSWp2I","title":"Basic formatting","pathname":"/planning-sheets/how-tos/basic-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"EyGNjzwqnB1ukDRJfEyq","title":"Number formatting","pathname":"/planning-sheets/how-tos/basic-formatting/number-formatting","siteSpaceId":"sitesp_ofx2Z","description":"Plan for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table/matrix style reports.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"DdORdsuq4X3JclMGYIdo","title":"Cell, header & value formatting","pathname":"/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"lSwDqdFQXNVTpL2udjqI","title":"Total and Subtotals","pathname":"/planning-sheets/how-tos/basic-formatting/total-and-subtotals","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Basic formatting"}]},{"id":"S2Sdr6Saw4BGfC96D9Ad","title":"Optimize overview","pathname":"/planning-sheets/how-tos/optimize-overview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"rfNcrBftrfcyt31I0pwc","title":"Maximize or minimize a target value","pathname":"/planning-sheets/how-tos/optimize-overview/maximize-or-minimize-a-target-value","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Optimize overview"}]},{"id":"U0FBYMlrBSZ8qQf7i6Vp","title":"Optimize input values to meet a target","pathname":"/planning-sheets/how-tos/optimize-overview/optimize-input-values-to-meet-a-target","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Optimize overview"}]},{"id":"G3gIxucNS0k4IKnPJNU2","title":"Use Optimize on derived measures and allocation rules","pathname":"/planning-sheets/how-tos/optimize-overview/use-optimize-on-derived-measures-and-allocation-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Optimize overview"}]},{"id":"WMoGzdr3EL0UqutiytaA","title":"Configure approval workflows","pathname":"/planning-sheets/how-tos/configure-approval-workflows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"9btFGkfNsBdI76WrBF0E","title":"Connected planning","pathname":"/planning-sheets/how-tos/infobridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"SwliBW8cfMAgmOF5LQFJ","title":"Create a bridge to integrate and transform plans","pathname":"/planning-sheets/how-tos/infobridge/1.-create-bridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"DJjG8XvvVFUUpW8epG9o","title":"Blend measures by using Infobridge","pathname":"/planning-sheets/how-tos/infobridge/blend-measures-by-using-infobridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"Due8bZcgEc8DXe0Z7syN","title":"Import data into a bridge","pathname":"/planning-sheets/how-tos/infobridge/2.-add-source-to-bridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"N1eiwDxiZdnKEzto3NKk","title":"Manage query operations","pathname":"/planning-sheets/how-tos/infobridge/4.-manage-queries","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"v2NVz3iClf92v2B8dCek","title":"Manage sources","pathname":"/planning-sheets/how-tos/infobridge/manage-sources","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"h7odTxaNMvRGvA6ONUEB","title":"Share measures","pathname":"/planning-sheets/how-tos/infobridge/share-measures","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"u65ZysHGAjgprogpaO4j","title":"Consolidate data between sheets","pathname":"/planning-sheets/how-tos/infobridge/import-measures-between-planning-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"j2Dub180kD3X5AtvhicS","title":"Use dimension level","pathname":"/planning-sheets/how-tos/infobridge/use-dimension-level","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"AzpcSN8sE56mSHM47fUF","title":"Data transformations","pathname":"/planning-sheets/how-tos/infobridge/data-transformations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"J4bavjbHMVxbDFYtWlAy","title":"Use pivot table","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/pivot-table","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"CPDZdDHgwR7CblAEXH0G","title":"Group by transformations","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/group-by","siteSpaceId":"sitesp_ofx2Z","description":"Learn how to aggregate and summarize detailed reports with the Group by transformation.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"73iilL9z3zPsEWOKtLXK","title":"Add Column","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/add-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"867ZKHK8aGH5iVSN5rZW","title":"Pivot and unpivot columns","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/pivot-columns-unpivot-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"jcCJk0Hl3LnUaWwjXQrM","title":"Rename column","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/rename-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"tzCCeKDTMQLz9I5zyAdP","title":"Use Find and Replace","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/find-and-replace","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"jnD1KlvD2vo0iflysqZi","title":"Remove column","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/remove-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"ro9I4AjYQz0PM0FCGwhR","title":"Filter rows","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/filter-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"COXIDBv7XAuhHt5LMJgX","title":"Sort","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/sort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"Ly6p3rDbZ27mvCMcbeoM","title":"Text functions","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/text-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"qpCn2vy5qKHr4EkTMBGB","title":"Unnest","pathname":"/planning-sheets/how-tos/infobridge/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":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"7keiq1ADO3o6VidDobgp","title":"Round","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/round","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"FOIZm9oj58hUm8ASGkNP","title":"Extract Comments","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/extract-comments","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"woCB0ecyr7qlomX7AsQB","title":"Import and export transformation steps","pathname":"/planning-sheets/how-tos/infobridge/data-transformations/import-and-export","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Data transformations"}]},{"id":"0TS4J0E33GNr4HbAEGk3","title":"Query transformations","pathname":"/planning-sheets/how-tos/infobridge/query-transformations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"0J2TTBFDgV32nvKoVYJZ","title":"Append Queries","pathname":"/planning-sheets/how-tos/infobridge/query-transformations/append","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Query transformations"}]},{"id":"pj8VL7MKD6uygSzslN1y","title":"Join queries","pathname":"/planning-sheets/how-tos/infobridge/query-transformations/join","siteSpaceId":"sitesp_ofx2Z","description":"Explore how to leverage joins to retrieve data from multiple tables using a related column.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Query transformations"}]},{"id":"QpwM83Bph4UbNFCq6cHi","title":"Merge queries","pathname":"/planning-sheets/how-tos/infobridge/query-transformations/merge-queries","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Query transformations"}]},{"id":"3wbgKa36cR7hKsisG1eK","title":"SQL queries","pathname":"/planning-sheets/how-tos/infobridge/query-transformations/sql-queries","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Query transformations"}]},{"id":"OrvPvrhsoIWQdQGcCClK","title":"Duplicate a query","pathname":"/planning-sheets/how-tos/infobridge/query-transformations/duplicate-a-query","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"},{"label":"Query transformations"}]},{"id":"D04fG5CuRWDf2TK9QNbM","title":"Writeback transformed data from InfoBridge","pathname":"/planning-sheets/how-tos/infobridge/writeback-transformed-data-from-infobridge","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Connected planning"}]},{"id":"e5NYgIKB2XDvvTsASyae","title":"Manage security in planning","pathname":"/planning-sheets/how-tos/manage-security-in-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"fV7uwbdZ8XaLNqu4DQg9","title":"Reference","pathname":"/planning-sheets/reference","siteSpaceId":"sitesp_ofx2Z","icon":"book-bookmark","description":"","breadcrumbs":[{"label":"Planning Sheets"}]},{"id":"ZFTFsgwv0bRdrLoSHcmC","title":"Formula syntax","pathname":"/planning-sheets/reference/formula-syntax","siteSpaceId":"sitesp_ofx2Z","icon":"function","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"}]},{"id":"sa4NQI7P13MQxpK5GuRE","title":"Conditional statements","pathname":"/planning-sheets/reference/formula-syntax/conditional-statements","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"nszR6GLXPDZRYJlf8uo1","title":"Logical functions","pathname":"/planning-sheets/reference/formula-syntax/logical-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"Y712qvACJKscliWpkgIR","title":"Math functions","pathname":"/planning-sheets/reference/formula-syntax/math-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"UsCxpkfhBIeCpvlqnWNx","title":"ABS","pathname":"/planning-sheets/reference/formula-syntax/math-functions/abs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"JBoRRVj5qT9rdqIsWmtw","title":"AVERAGE","pathname":"/planning-sheets/reference/formula-syntax/math-functions/average","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"NEn6c0ucJMJS3HRphoBE","title":"AVERAGEEXNEG","pathname":"/planning-sheets/reference/formula-syntax/math-functions/averageexneg","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BadHKyTHhL5Jow3IfqDe","title":"AVERAGEEXZERO","pathname":"/planning-sheets/reference/formula-syntax/math-functions/averageexzero","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3272xD4VM7ZllCoffQFK","title":"AVERAGEEXZERONEG","pathname":"/planning-sheets/reference/formula-syntax/math-functions/averageexzeroneg","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vEPEvcXwCO46Tdsva8MD","title":"CEILING","pathname":"/planning-sheets/reference/formula-syntax/math-functions/ceiling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Yz1XlakVaVicTypHYc3w","title":"COUNT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/count","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"qxOMGC31bXZW9HrCyx8q","title":"DIVIDE","pathname":"/planning-sheets/reference/formula-syntax/math-functions/divide","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"QKvQ7PxOJVtutBvts03M","title":"EVEN","pathname":"/planning-sheets/reference/formula-syntax/math-functions/even","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"emWtv4FFTn04pXfhw6DX","title":"EXP","pathname":"/planning-sheets/reference/formula-syntax/math-functions/exp","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"gF0dt7epJsFddE5eH4uz","title":"ODD","pathname":"/planning-sheets/reference/formula-syntax/math-functions/odd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"m0JQYMdN9r3n5IyAT1dD","title":"FLOOR","pathname":"/planning-sheets/reference/formula-syntax/math-functions/floor","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"WqBOIHuaEwVDQqdaauFH","title":"INDEXOF","pathname":"/planning-sheets/reference/formula-syntax/math-functions/indexof","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Z4U3PCqjuI5n6wBj6ubh","title":"LARGE","pathname":"/planning-sheets/reference/formula-syntax/math-functions/large","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"Wr4yqb6iXLHD5zRNRU0l","title":"LOG","pathname":"/planning-sheets/reference/formula-syntax/math-functions/log","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"3EFiglugR1swOi2FSGHR","title":"MAX","pathname":"/planning-sheets/reference/formula-syntax/math-functions/max","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"vhKySa8nxw1HsxzSYfAT","title":"MIN","pathname":"/planning-sheets/reference/formula-syntax/math-functions/min","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"J3Ixjvc37u6ecoy50zVg","title":"MOD","pathname":"/planning-sheets/reference/formula-syntax/math-functions/mod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"87iRaaIkgF8zQ1bb5dcK","title":"MROUND","pathname":"/planning-sheets/reference/formula-syntax/math-functions/mround","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"VNOEuMvgvsechnp3HJLv","title":"NUMBERVALUE","pathname":"/planning-sheets/reference/formula-syntax/math-functions/numbervalue","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"OoXC4lVcrncPNsiqQrVC","title":"PCT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/pct","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"iDlNEDwAUxgvBKZX0Q1Y","title":"POWER","pathname":"/planning-sheets/reference/formula-syntax/math-functions/power","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"FpgyByr276AQGyexzgsS","title":"PRODUCT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/product","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"SrnWvW6IO4XBQDo9cWYW","title":"RAND","pathname":"/planning-sheets/reference/formula-syntax/math-functions/rand","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"cCH0BNIPvuujCbjgWaYU","title":"RANDBETWEEN","pathname":"/planning-sheets/reference/formula-syntax/math-functions/randbetween","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9IftHeKRBsT66Cdtbbi0","title":"ROUND","pathname":"/planning-sheets/reference/formula-syntax/math-functions/round","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"6qKbTEJh9m1uiEax06En","title":"ROUNDDOWN","pathname":"/planning-sheets/reference/formula-syntax/math-functions/rounddown","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"PFEret02HvsFgOhVWdem","title":"ROUNDUP","pathname":"/planning-sheets/reference/formula-syntax/math-functions/roundup","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KI14FGEgbTLR5xxRC2Vx","title":"SORT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/sort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"KKh8oNJNUQ2n3sFqtgeK","title":"SUBTRACT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/subtract","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9fSeuxMzFkSvivzRB75w","title":"SUM","pathname":"/planning-sheets/reference/formula-syntax/math-functions/sum","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"bQSQqzRJ81ZuAhmveCFj","title":"SMALL","pathname":"/planning-sheets/reference/formula-syntax/math-functions/small","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"9NMOWKVDC2stURMGJTeq","title":"SQRT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/sqrt","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"TdwoA2okNhO3dwU5u9zh","title":"PMT","pathname":"/planning-sheets/reference/formula-syntax/math-functions/pmt","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Math functions"}]},{"id":"BMGkg1oP6zydDkD8zZ0P","title":"Text formatting functions","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"JsxnHKVi2GyDn4isikHv","title":"CONCATENATE","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/concatenate","siteSpaceId":"sitesp_ofx2Z","description":"Joins multiple text strings into one single combined text value.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"23x61Jh9B10z08jWhM1M","title":"CONCATALL","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/concatall","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"8TGXVBwfVh6l0ti8spVH","title":"HYPERLINK","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/hyperlink","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"iwdfyXYiptRr3UDNgMM7","title":"LEFT","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/left","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7H4nLGn6MvzW7vilMH9H","title":"LOWER","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/lower","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nmtAbjW05cE6e3qUgo4B","title":"MID","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/mid","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"vPVHsLeoR4HZMAHlbFEK","title":"PROPER","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/proper","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"7Ifnl94GmKrz0zQqF5Bg","title":"REPLACE","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/replace","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"XwFAmVMgwDmWVnN733Ia","title":"REPT","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/rept","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"OHZ2AR56yk7gG2AZoFaS","title":"RIGHT","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/right","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eM68wWzZaozymrIFGnJ2","title":"TEXT","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/text","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"ReWAum7B2uv0uIvOdX5b","title":"TRIM","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/trim","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"nTTfeHCTKEMhWfKfKIes","title":"UPPER","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/upper","siteSpaceId":"sitesp_ofx2Z","description":"Converts text to uppercase letters.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"Tjz7486zqnWso5drV9Lx","title":"VALUE","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/value","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"QPS0AdBYFCX09xsRHhCL","title":"LEN","pathname":"/planning-sheets/reference/formula-syntax/text-formatting-functions/len","siteSpaceId":"sitesp_ofx2Z","description":"Returns the number of characters in a text string, including spaces and special characters.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Text formatting functions"}]},{"id":"eXVJI8jCvDVYjUyn1ywt","title":"Date functions","pathname":"/planning-sheets/reference/formula-syntax/date-functions","siteSpaceId":"sitesp_ofx2Z","description":"Date functions allow you to create, format, extract, calculate, and manipulate date and time values.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"qVfA99bRrGZXkLxjTdI2","title":"DATEADD","pathname":"/planning-sheets/reference/formula-syntax/date-functions/dateadd","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wKy6tGd7hpcbDoONmNB3","title":"DATEDIFF","pathname":"/planning-sheets/reference/formula-syntax/date-functions/datediff","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"J9R2BlAJNEsB0L3BC1DC","title":"DAY","pathname":"/planning-sheets/reference/formula-syntax/date-functions/day","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"A4mxYUJbgr8b35z9CxIz","title":"DATE","pathname":"/planning-sheets/reference/formula-syntax/date-functions/date","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"HGH9dH5o8MIGttLPw5Qd","title":"DATE.FORMAT","pathname":"/planning-sheets/reference/formula-syntax/date-functions/date.format","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"bcMGmuvLTr3vDKZfw9qS","title":"SOWEEK","pathname":"/planning-sheets/reference/formula-syntax/date-functions/soweek","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"wbjBcP9coYYEOUpLMHyr","title":"SOMONTH","pathname":"/planning-sheets/reference/formula-syntax/date-functions/somonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lV0Dp9hDOhu8YEeGd4cf","title":"SOQTR","pathname":"/planning-sheets/reference/formula-syntax/date-functions/soqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"NYBuNeVEWZmG5Ttu7W9g","title":"SOYEAR","pathname":"/planning-sheets/reference/formula-syntax/date-functions/soyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8gKgjrCuSOEReXuZ4eqY","title":"EOWEEK","pathname":"/planning-sheets/reference/formula-syntax/date-functions/eoweek","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"niIioqUL1koas300LGwV","title":"EOMONTH","pathname":"/planning-sheets/reference/formula-syntax/date-functions/eomonth","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"MN1p5ucOtTjH4rVEIGM0","title":"EOQTR","pathname":"/planning-sheets/reference/formula-syntax/date-functions/eoqtr","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"YvZG1wFGX1yXoGj1qgKJ","title":"EOYEAR","pathname":"/planning-sheets/reference/formula-syntax/date-functions/eoyear","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"Qk4e6FSt8kPxV3a0pyXm","title":"NETWORKDAYS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/networkdays","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"O5lK39AMduZKUkvCTgIX","title":"ADDDAYS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/adddays","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"N1VC39UfVve2Zcp6TmMl","title":"ADDWEEKS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/addweeks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"sqI0jB4XJpSmwghRArTv","title":"ADDMONTHS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/addmonths","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"trVFvAdthZUExnaXcvg3","title":"ADDQTRS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/addqtrs","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"vNBFlIVhOprshu2i6J6W","title":"ADDYEARS","pathname":"/planning-sheets/reference/formula-syntax/date-functions/addyears","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"jyoFhX0KIQqrkKSBfjqV","title":"FROM_EXCELDATE","pathname":"/planning-sheets/reference/formula-syntax/date-functions/fromexceldate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"cb1rhIEIRnJwf7A5FTLK","title":"MONTH","pathname":"/planning-sheets/reference/formula-syntax/date-functions/month","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"VBYmoI98unLBA8GHFSQx","title":"DATE.NOW","pathname":"/planning-sheets/reference/formula-syntax/date-functions/now","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"2a3gIkLJaTFHcvBd2Xgp","title":"PERIOD_RANGE","pathname":"/planning-sheets/reference/formula-syntax/date-functions/period_range","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"lvA0OuKtVw6WEcp8sNXB","title":"TO_EXCELDATE","pathname":"/planning-sheets/reference/formula-syntax/date-functions/toexceldate","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"8yot6HgUik49mFNCaWQJ","title":"YEAR","pathname":"/planning-sheets/reference/formula-syntax/date-functions/year","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Date functions"}]},{"id":"uojh5KjZPJJ5LNHSxbfl","title":"Time intelligence functions","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"GUPv06U0bkS9ZGseqVIQ","title":"Relative time periods","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions/relative-time-periods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"F9KX620F1TsReTcqcaSH","title":"Specific time periods","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions/specific-time-periods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"dlX1uk5H2cT2YoEVQk64","title":"Period-to-date calculations","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions/period-to-date-calculations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"qsXzYm2TTHCHylBUeDA9","title":"Time-based aggregations","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions/time-based-aggregations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"DBGcliWiVTJZQOLfpSUN","title":"Time shifting and lookup","pathname":"/planning-sheets/reference/formula-syntax/time-intelligence-functions/time-shifting-and-lookup","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Time intelligence functions"}]},{"id":"YG8TtafyR5w5jOKcECoL","title":"Other operators","pathname":"/planning-sheets/reference/formula-syntax/other-operators","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"MVJkdAbfiCCBPvcToOEd","title":"Identifiers","pathname":"/planning-sheets/reference/formula-syntax/identifiers","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"32tj1QOKaWwH88GWvORC","title":"Identifiers","pathname":"/planning-sheets/reference/formula-syntax/identifiers/identifiers","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Identifiers"}]},{"id":"c8wML0XeCmptUsU3Aisg","title":"Scripting functions","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"LLDV5RBYGTrHpPHM0Khk","title":"DISPLAYTOAST","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/displaytoast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4GmnEVa5jx53JkCkLWJM","title":"EXPORT","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/export","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"4aVL4ji6z5ezqORkKOpL","title":"LAYOUT","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"zx5FdTu6Ft3jsPJI2yaj","title":"OPENKPIEXPLORER","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/openkpiexplorer","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"IYggoazsrSx7yLhuHJNy","title":"OPENMANAGECOLUMN","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/openmanagecolumn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KkbsQMI89pCwJwy2Pi4Q","title":"OPENSEARCH","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/opensearch","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"WIyrK8hj0bD3vnDmpLcj","title":"OPENTOPN","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/opentopn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"pL2hKOtmZbtdOgwpo58D","title":"SENDMAIL","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/sendmail","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EBhDPDhxF8Q2jaQIK1r1","title":"SETCFRULE","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setcfrule","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BjzJwN1LySH4qIXvPahD","title":"SETCOLUMNSORT","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setcolumnsort","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"UyqFjPmSRPZ30vDqdpDB","title":"SETFILTER","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setfilter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"n3DcyJZGOJTC57eTFvlw","title":"SETFILTERBYINDEX","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setfilterbyindex","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"EFJgsliL5VhlP0wSeSBE","title":"SETFONTSIZE","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setfontsize","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"dPscm5R3D0lHhSPMZdP3","title":"SETFOOTER","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setfooter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"C9BFvHgLRBk04CN6JVc3","title":"SETHEADER","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setheader","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"tPpqVONU7j0GHraFOBut","title":"SETLOCK","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setlock","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"oJDbB7oJT9OPgZyNTipm","title":"SETMEASURETITLE","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setmeasuretitle","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"VoH2cUmPDXdV5Nzg6NJg","title":"SETMAXDECIMALPRECISION","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setmaxdecimalprecision","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"poBtFcBhbxo3xFe3KdEp","title":"SETPAGINATION","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setpagination","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"nNlqWPq85ceLsq7oa5oV","title":"SETSCALING","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setscaling","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"w50qN7scOF8utUfsr4Ot","title":"SETSEMANTICFORMATTING","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setsemanticformatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"neci4NTB6cGptXIWcfEO","title":"SETSTATUSBAR","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setstatusbar","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"mlC8yab6rUOvBCGFq80h","title":"SETVALUE","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setvalue","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"BadWz6cZ3g2vkCHqWf37","title":"SETVISIBILITY","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/setvisibility","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"Oe1ME4WmbWJJymMznXBW","title":"SHOWBETWEENPERIOD","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/showbetweenperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"ouwnYuvuaAKu50TsGkGm","title":"SHOWCLOSEDFORECAST","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/showclosedforecast","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"KIfIYACONM1pShrL0sg7","title":"SHOWMEASUREBETWEENPERIOD","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/showmeasurebetweenperiod","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"42iAW4rINxgPxReb6P78","title":"TOPN","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/topn","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"e7KJ9e2hU3eXiQQob8IV","title":"DISPLAY SETTINGS","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"}]},{"id":"0dHCqB6hdGvJqgBaW6QG","title":"SETBLANKLABEL","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setblanklabel","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"LHPp7khRgkfOeg6dzDay","title":"SETSUPPRESSZEROS","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setsuppresszeros","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"GE3RkOh1U6H7RKB9A5Yx","title":"SETRAGGEDHIERARCHY","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setraggedhierarchy","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"fyMZa1h0LmKfgwUuVY44","title":"SEPARATOR","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/separator","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"nadzc0BtlUKKyNI4vurt","title":"SETCOMBINECOLUMNHEADER","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"2f4FRNENJgyL64KOa6jB","title":"SEMANTICFORMAT","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/semanticformat","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"UGWrsro5DJyNHdoLhmRc","title":"SHOWNULLAS","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/shownullas","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"8nTjWaqDYswWJg3IlQIm","title":"SHOWZEROAS","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/showzeroas","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"v9N787dOqyh93Hjqv5rW","title":"SINGLECHILD","pathname":"/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/singlechild","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Scripting functions"},{"label":"DISPLAY SETTINGS"}]},{"id":"VMXodINSF8idYNV272BN","title":"Statistical Functions","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions","siteSpaceId":"sitesp_ofx2Z","description":"Analyze data using statistical functions to summarize, measure variation, and uncover insights.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"y7fkj2k4xRQHt4p6bx6n","title":"Calculate measures of central tendency","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions/calculate-measures-of-central-tendency","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"Pms581ZXF9B898czRIj5","title":"Calculate ranking and quartiles","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions/calculate-ranking-and-quartiles","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"lHjR2aKPwuOpooGSxgwh","title":"Calculate variance and standard deviation","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions/calculate-variance-and-standard-deviation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"uwJawRp8YNkLFRx8GAvn","title":"Calculate percentiles and percent ranks","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions/calculate-percentiles-and-percent-ranks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"Z0aF0aeAmS4ZhmD9bOHv","title":"Calculate normal distribution values","pathname":"/planning-sheets/reference/formula-syntax/statistical-functions/calculate-normal-distribution-values","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Statistical Functions"}]},{"id":"yuV75wmoqHiuaMfP6iTv","title":"Miscellaneous functions","pathname":"/planning-sheets/reference/formula-syntax/miscellaneous-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"tgd1osdxp2InLMYQhRy9","title":"FETCH","pathname":"/planning-sheets/reference/formula-syntax/miscellaneous-functions/fetch","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"GCJX3L5qUnEsWe8wJ1gr","title":"LOOKUP","pathname":"/planning-sheets/reference/formula-syntax/miscellaneous-functions/lookup","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Miscellaneous functions"}]},{"id":"CvdjurcX9xjYHS1efSP8","title":"Measure/Column selection functions","pathname":"/planning-sheets/reference/formula-syntax/measure-column-selection-functions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"fGIagCrV70fAp3IK67cG","title":"GETCOLBETWEENPERIODS","pathname":"/planning-sheets/reference/formula-syntax/measure-column-selection-functions/getcolbetweenperiods","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"iZ4HfZZTZDkLABXd3YBG","title":"GETMEASURE","pathname":"/planning-sheets/reference/formula-syntax/measure-column-selection-functions/getmeasure","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"8SmH8nzTlk9Wkg3Ea3nB","title":"SELECT","pathname":"/planning-sheets/reference/formula-syntax/measure-column-selection-functions/select","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"WFhSO3nZhsxAgmxtk2XW","title":"SELECT_BYINDEX","pathname":"/planning-sheets/reference/formula-syntax/measure-column-selection-functions/select_byindex","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"},{"label":"Measure/Column selection functions"}]},{"id":"29BAykaJUxcDwovlW7tt","title":"Lookup functions - XLOOKUP","pathname":"/planning-sheets/reference/formula-syntax/lookup-functions-xlookup","siteSpaceId":"sitesp_ofx2Z","description":"XLOOKUP is used for condition-based measure lookups. XLOOKUP finds rows that match one or more dimension conditions and returns the requested measure value.","breadcrumbs":[{"label":"Planning Sheets"},{"label":"Reference","icon":"book-bookmark"},{"label":"Formula syntax","icon":"function"}]},{"id":"MO6cmajdVKtSZzriC5MC","title":"Concepts","pathname":"/powertable-sheets/concepts","siteSpaceId":"sitesp_ofx2Z","icon":"calendar-check","description":"","breadcrumbs":[{"label":"PowerTable sheets"}]},{"id":"ncITMs3U020JgxNP8msL","title":"Slowly changing dimensions","pathname":"/powertable-sheets/concepts/type-2-scds","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"3Y0yYb29hDtFApWXlTdp","title":"Automation","pathname":"/powertable-sheets/concepts/automation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"l3jl2lozhKaPmQ3FSdKN","title":"Gantt layout","pathname":"/powertable-sheets/concepts/gantt-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"Concepts","icon":"calendar-check"}]},{"id":"aMXgfTxfc79qqghkwtr9","title":"How-tos","pathname":"/powertable-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"PowerTable sheets"}]},{"id":"YCxfTUrNRn1e80j6nHJK","title":"Create a table app","pathname":"/powertable-sheets/how-tos/create-a-table-app","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"tT80TQzsvkntHUi2WKy0","title":"Connect to a Database","pathname":"/powertable-sheets/how-tos/create-a-table-app/connect-to-a-database","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Create a table app"}]},{"id":"iBIMXtjC9x0v8EI0Dw3f","title":"Enter Data Manually","pathname":"/powertable-sheets/how-tos/create-a-table-app/enter-data-manually","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Create a table app"}]},{"id":"c2IKHSV0LhbpY24wmfBY","title":"Connect to a semantic model","pathname":"/powertable-sheets/how-tos/create-a-table-app/connect-powertable-sheet-to-a-semantic-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Create a table app"}]},{"id":"qtrFqa0W4r933jywz4aO","title":"Create PowerTable Sheets FAQ","pathname":"/powertable-sheets/how-tos/create-a-table-app/create-powertable-sheets-faq","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Create a table app"}]},{"id":"teWzpI7UxTaQmULq37Dw","title":"Data management","pathname":"/powertable-sheets/how-tos/basic-table-operations","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"9b9a91abafae7b92393ed7e92e2b16ea8d5825bf","title":"Edit and Bulk-edit data","pathname":"/powertable-sheets/how-tos/basic-table-operations/edit-and-bulk-edit-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Data management"}]},{"id":"xsowk8f2TSywWLPJpIOe","title":"Preview Changes","pathname":"/powertable-sheets/how-tos/basic-table-operations/preview-changes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Data management"}]},{"id":"uJJ8v6M4cq7y0uBZqDNa","title":"Explore and organize data","pathname":"/powertable-sheets/how-tos/explore-and-organize-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"jpioTXGELb46XiZURv5V","title":"Filter data","pathname":"/powertable-sheets/how-tos/explore-and-organize-data/filter-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Explore and organize data"}]},{"id":"fbDA5HnzqdoMEoupvBTM","title":"Group rows","pathname":"/powertable-sheets/how-tos/explore-and-organize-data/group-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Explore and organize data"}]},{"id":"a9179689701ae2bda3829d8a7596c17fabfdc62c","title":"Insert, import, duplicate, and delete rows","pathname":"/powertable-sheets/how-tos/insert-import-duplicate-and-delete-rows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"8023aeee8209173d38ab88d9a11e5825a2f4bac6","title":"Add Columns - Overview","pathname":"/powertable-sheets/how-tos/adding-columns-overview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"c575729f8aeca15ada3ad53d0ed2e53c55fed90b","title":"Add visual column overview","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"ae1c321761d999343109cb5f3851c8ff42311328","title":"Multiselect relationship column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/relation-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/button-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/attachments-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/adding-columns-overview/add-database-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"c11350c45d8894603daaf0839a8f0951851c83b4","title":"Add Formula Column","pathname":"/powertable-sheets/how-tos/adding-columns-overview/add-formula-column","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Add Columns - Overview"}]},{"id":"d1f6cf9199e2de9083880ad48b48ec4e0a887553","title":"Configure column properties","pathname":"/powertable-sheets/how-tos/configure-column-properties","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"43a382c2b2837292159d8423d6e01e66424cfa56","title":"General","pathname":"/powertable-sheets/how-tos/configure-column-properties/general","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure column properties"}]},{"id":"ff5d993b3716c2851407fbc743a53ae5eb28c80e","title":"Display","pathname":"/powertable-sheets/how-tos/configure-column-properties/display","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure column properties"}]},{"id":"80863bc933c5ae576c37853b781ef44bd7675bd4","title":"Lookup and relation","pathname":"/powertable-sheets/how-tos/configure-column-properties/lookup-and-relation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"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":"/powertable-sheets/how-tos/set-up-row-and-column-access-control","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"5247964e6086f421316bb292a701da517fa31110","title":"Manage Columns","pathname":"/powertable-sheets/how-tos/manage-columns","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ebc1d58ec9b06b5b848b436216cdf620455df4d8","title":"Change column widths","pathname":"/powertable-sheets/how-tos/manage-columns/change-column-widths","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Manage Columns"}]},{"id":"7f41d8d534868b21a74a65364179abf6add1e384","title":"Configure layouts","pathname":"/powertable-sheets/how-tos/layout-views-summary","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"071719f5aba1b9c348821704e61fa2052add04a0","title":"Hierarchy","pathname":"/powertable-sheets/how-tos/layout-views-summary/hierarchy-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"tMXF9iDKNQLsDnJDWqjs","title":"Crosstab","pathname":"/powertable-sheets/how-tos/layout-views-summary/crosstab","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"WZOGMx6E2jSgWsyU6zXu","title":"Resource","pathname":"/powertable-sheets/how-tos/layout-views-summary/resource","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"A0rrsQCoLwulrdtpqxoF","title":"Overview","pathname":"/powertable-sheets/how-tos/layout-views-summary/resource/overview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Resource"}]},{"id":"0y6BAR5FVHufPCWneOfV","title":"Add and manage tasks","pathname":"/powertable-sheets/how-tos/layout-views-summary/resource/add-and-manage-tasks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Resource"}]},{"id":"8118532677a619d6e9340551bce268149ebe98c7","title":"Customize resource layout","pathname":"/powertable-sheets/how-tos/layout-views-summary/resource/resource-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Resource"}]},{"id":"decda3fe2c1e7b4bcb39435573e59321e296e408","title":"Gantt","pathname":"/powertable-sheets/how-tos/layout-views-summary/gantt-chart-view","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"w2tzZ7DLgptBS35wKVS2","title":"Calendar","pathname":"/powertable-sheets/how-tos/layout-views-summary/calendar","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"Ubfx3itxnCnANCv1dC69","title":"Overview","pathname":"/powertable-sheets/how-tos/layout-views-summary/calendar/calendar-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Calendar"}]},{"id":"n4cbLT2dGlqmQjzlSpZ5","title":"Add and manage tasks","pathname":"/powertable-sheets/how-tos/layout-views-summary/calendar/add-and-manage-tasks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Calendar"}]},{"id":"v1wzV4vA20wNirlMP0QT","title":"Navigate and customize calendar layout","pathname":"/powertable-sheets/how-tos/layout-views-summary/calendar/navigate-and-customize-calendar-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Calendar"}]},{"id":"PhhoVRSnJkBlTKOvzVQP","title":"Kanban","pathname":"/powertable-sheets/how-tos/layout-views-summary/kanban","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"}]},{"id":"5eMgeBHc2rzsL7N2ebQ2","title":"Overview","pathname":"/powertable-sheets/how-tos/layout-views-summary/kanban/kanban-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Kanban"}]},{"id":"hNd9K2kLSCTRJVWcE4CL","title":"Add and manage tasks","pathname":"/powertable-sheets/how-tos/layout-views-summary/kanban/add-and-manage-tasks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Kanban"}]},{"id":"jCY6h19lzDzZJtmgS3ek","title":"Customize Kanban layout","pathname":"/powertable-sheets/how-tos/layout-views-summary/kanban/customize-kanban-layout","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Configure layouts"},{"label":"Kanban"}]},{"id":"NnmvdHyyKHJSf6fVtPh7","title":"Create data entry forms","pathname":"/powertable-sheets/how-tos/generate-forms","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"QEYkFb5oxJWLQg5ACH5f","title":"Approval flow","pathname":"/powertable-sheets/how-tos/approval-flow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"azKSmaWp8Z4BPdMdBIcU","title":"Configure approval workflow","pathname":"/powertable-sheets/how-tos/approval-flow/configure-approval-workflow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"7DP9tAXqTqytlNCynmCZ","title":"Review changes in PowerTable approval workflow","pathname":"/powertable-sheets/how-tos/approval-flow/review-changes-in-powertable-approval-workflow","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Approval flow"}]},{"id":"yPcwFjN1tsQXyIQXQJlX","title":"Automation","pathname":"/powertable-sheets/how-tos/automation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZocxMXEjBpkmLpMq6t9Z","title":"Configure automation workflows","pathname":"/powertable-sheets/how-tos/automation/configure-automation-workflows","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Automation"}]},{"id":"FYKQLGqK4diSQQlxAymz","title":"Create a sample automation","pathname":"/powertable-sheets/how-tos/automation/create-a-sample-automation","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Automation"}]},{"id":"xGP6xgg94Jj1dcpZXROB","title":"Commenting and collaboration","pathname":"/powertable-sheets/how-tos/commenting-and-collaboration","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"TIAHE19sjZPe9RvVFvU6","title":"Export to Excel","pathname":"/powertable-sheets/how-tos/export-powertable-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"7D9Bb5mQJAEKyE47VUJ1","title":"Export to PDF","pathname":"/powertable-sheets/how-tos/export-to-pdf","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"FeqsyI3m8UlqLY8AyNVI","title":"Conditional Formatting","pathname":"/powertable-sheets/how-tos/conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"HC7jnJ4OStgvDFjwf7UO","title":"Audit log","pathname":"/powertable-sheets/how-tos/audit-log","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"QkfnhNHSxz7B9au760Q3","title":"Create slowly changing dimensions","pathname":"/powertable-sheets/how-tos/create-slowly-changing-dimensions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"GU9LcIP89dDv27kduX7a","title":"Appearance settings","pathname":"/powertable-sheets/how-tos/appearance-settings","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"3Y6QLnpZQzWESAcq1Bwx","title":"Reference","pathname":"/powertable-sheets/reference","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"}]},{"id":"dc805c9ba2907eb323244357c3de7042c0040f0a","title":"Supported column and input types","pathname":"/powertable-sheets/reference/supported-column-types","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"Reference"}]},{"id":"oqHIlE5sBulvNAalwaWQ","title":"Supported file types for attachment","pathname":"/powertable-sheets/reference/supported-file-types-for-attachment","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"PowerTable sheets"},{"label":"Reference"}]},{"id":"iyINGCFbJ6iGmmK7zSAb","title":"How-tos","pathname":"/intelligence-sheets/how-tos","siteSpaceId":"sitesp_ofx2Z","icon":"book-open-lines","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"}]},{"id":"Le56AiOcpKpxNQoxDRxe","title":"Get started with Intelligence sheets","pathname":"/intelligence-sheets/how-tos/get-started-with-intelligence-sheets","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"AucLZAq1IPlj5boxspU5","title":"Get started with reporting","pathname":"/intelligence-sheets/how-tos/get-started-with-reporting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ahmVnWS0Dd5GaJOnIPHD","title":"Apply conditional formatting","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ZJPmNKa5xg6k9jUFOjYN","title":"Showcase data points in charts","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/showcase-data-points-in-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"cgvjzLWX04Gn8dhIGhPP","title":"Highlight tabular data with conditional formatting","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/highlight-tabular-data-with-conditional-formatting","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"txnVsNgKPu71v2Yo9wls","title":"Create rules","pathname":"/intelligence-sheets/how-tos/apply-conditional-formatting/create-rules","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply conditional formatting"}]},{"id":"SsibLLqx7GCpXlj9XkHn","title":"Build financial reports","pathname":"/intelligence-sheets/how-tos/build-financial-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hZzZD6HvBNynva3tVI3u","title":"Collaborate on reports with comments","pathname":"/intelligence-sheets/how-tos/collaborate-on-reports-with-comments","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"GmHllVsQoNnbrQ1s4kXB","title":"Pagination and formatting for reports","pathname":"/intelligence-sheets/how-tos/pagination-and-formatting-for-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hlrllHW4TQfaK2fhqlj9","title":"Export high-quality PDF & Excel reports","pathname":"/intelligence-sheets/how-tos/export-high-quality-pdf-and-excel-reports","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"xD7g8p48pvAtcOdOjt0p","title":"Visualize simulations, budgets, and forecasts","pathname":"/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"ECVJ25muQ9oGi5S1F7I3","title":"Monitor project progress with Gantt charts","pathname":"/intelligence-sheets/how-tos/plan-projects-with-gantt-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Im1Ut4RCY3J7o7p2TPyx","title":"Retain report data with Writeback","pathname":"/intelligence-sheets/how-tos/retain-report-data-with-writeback","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"hbu6vyGjJ5MI99chhmjx","title":"Build multi-measure charts","pathname":"/intelligence-sheets/how-tos/build-multi-measure-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"82NC1fKYnMWbQj4F0l7X","title":"Use themes for consistent color schemes","pathname":"/intelligence-sheets/how-tos/use-themes-for-consistent-color-schemes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"4hM00zGijWU9r82TkkY4","title":"Ranking data","pathname":"/intelligence-sheets/how-tos/ranking-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"6jGqLfKPCf7K2qtUaIAF","title":"Sorting data","pathname":"/intelligence-sheets/how-tos/sorting-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"gyP45e9LgxShOCXxBflk","title":"Filter data","pathname":"/intelligence-sheets/how-tos/filter-data","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"K5FkCjaSlHzf9qDLu2Ke","title":"Add date filters","pathname":"/intelligence-sheets/how-tos/filter-data/add-date-filters","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"sAOF0RorswlZD7hbo9Mm","title":"Create a filter panel","pathname":"/intelligence-sheets/how-tos/filter-data/create-a-filter-panel","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"LvC4EBBZT4U86C6rk6AA","title":"Add a treemap filter","pathname":"/intelligence-sheets/how-tos/filter-data/add-a-treemap-filter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"w58LQGrchcdbhu8vTxWx","title":"Add a hierarchy filter","pathname":"/intelligence-sheets/how-tos/filter-data/add-a-hierarchy-filter","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Filter data"}]},{"id":"NIqP42Tw6AoERFpnrkMx","title":"Build a dashboard","pathname":"/intelligence-sheets/how-tos/build-a-dashboard","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"Nq1rMVfQlxN2QwNkW74I","title":"Apply IBCS formats","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"nl2aDFd8sOFC4HNmgYu4","title":"Column and bar charts","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/column-and-bar-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"3sjDXjXXdXx0GF1Xd8fd","title":"Waterfall charts","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/waterfall-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"C2b2U8NretiXNWwj7dm7","title":"Area and line charts","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/area-and-line-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"mzCbtKXO17mQcZxTFh80","title":"Scatter and bubble charts","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/scatter-and-bubble-charts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"mBgoscUjGvdm4uuYhYgZ","title":"Small multiples","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/small-multiples","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"kaqFlwAlCHSyVo47PW0c","title":"Table templates","pathname":"/intelligence-sheets/how-tos/apply-ibcs-formats/table-templates","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Apply IBCS formats"}]},{"id":"oNN3tA2zAj3oKGYPeE0Z","title":"Visualization library","pathname":"/intelligence-sheets/how-tos/visualization-library","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"VsqEoapRdND7aqiY0VNP","title":"Sankey chart","pathname":"/intelligence-sheets/how-tos/visualization-library/sankey-chart","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"1VevOLAUy8oetTr0FpMm","title":"Boxplot","pathname":"/intelligence-sheets/how-tos/visualization-library/boxplot","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"tvuRXRaYHB6RahLwuSNl","title":"Multi axis chart","pathname":"/intelligence-sheets/how-tos/visualization-library/multi-axis-chart","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"yTQHeYDbUOexHBbq5gsU","title":"Slope graph","pathname":"/intelligence-sheets/how-tos/visualization-library/slope-graph","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"DAiibUsVcVzz0kXxUpm4","title":"Network graph","pathname":"/intelligence-sheets/how-tos/visualization-library/network-graph","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"},{"label":"Visualization library"}]},{"id":"3EU1SS2BlD5MNS0WIyVZ","title":"Compare data with small multiples","pathname":"/intelligence-sheets/how-tos/compare-data-with-small-multiples","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"1UhhJmRDDptFCurHQzAb","title":"Context awareness","pathname":"/intelligence-sheets/how-tos/context-awareness","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"0rnNT7cKJSTHxsTaJtIf","title":"Switch between reading and editing modes","pathname":"/intelligence-sheets/how-tos/switch-between-reading-and-editing-modes","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"},{"label":"How-tos","icon":"book-open-lines"}]},{"id":"8MsT1dbPcNMXhUE72kJV","title":"Intelligence FAQ","pathname":"/intelligence-sheets/intelligence-faq","siteSpaceId":"sitesp_ofx2Z","icon":"messages-question","description":"","breadcrumbs":[{"label":"INTELLIGENCE SHEETS"}]},{"id":"Uk2qlWzrJeNx3L32E85U","title":"Billing and usage for planning in Fabric","pathname":"/resources/billing-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"zOhzSeRQbAUSwDMtArUH","title":"Roles in Fabric Plan","pathname":"/resources/roles-in-fabric-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"rJ5k2GPOnQgjpLAVVcxe","title":"Fiscal year setup in plan","pathname":"/resources/fiscal-year-setup-in-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"6mCwcTIHJlaRHjXE43TA","title":"Planning solutions with Org Apps","pathname":"/resources/planning-solutions-with-org-apps","siteSpaceId":"sitesp_ofx2Z","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"StOkLWFlLNX7jrBGKH9m","title":"Add bookmarks","pathname":"/resources/bookmarks","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"l7dOnlZk6T2X3kqg0njw","title":"FAQ","pathname":"/resources/faq","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"pVsUeENHradrElF2oWhW","title":"PowerTable general FAQ","pathname":"/resources/faq/powertable-general-faq","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"},{"label":"FAQ"}]},{"id":"4QrbLLlk4YIuoUUqWU3a","title":"Best practices","pathname":"/resources/best-practices","siteSpaceId":"sitesp_ofx2Z","description":"","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","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"},{"label":"Best practices"}]},{"id":"1hfG2gGwWkI3ToH0E2jO","title":"Semantic modeling best practices for planning","pathname":"/resources/best-practices/semantic-modeling-best-practices-for-planning","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"},{"label":"Best practices"}]},{"id":"VEjvb7Lk8il7fi70zm0G","title":"Troubleshoot","pathname":"/resources/troubleshoot","siteSpaceId":"sitesp_ofx2Z","icon":"screwdriver-wrench","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"RwkMI5mNfiSurdbaeWs2","title":"Error codes and resolutions","pathname":"/resources/error-codes-and-resolutions","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"uz01O120wTPdTlm5Wt1x","title":"Known Limitations in Plan","pathname":"/resources/known-limitations-in-plan-preview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"yhoI2pskOHnFzCj1xx8z","title":"Row-level security (RLS) behavior in Plan","pathname":"/resources/row-level-security-rls-behavior-in-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"piMMh2mfCLj8sXj4iasf","title":"Disaster recovery for Plan","pathname":"/resources/disaster-recovery-for-plan","siteSpaceId":"sitesp_ofx2Z","description":"Experience-Specific Recovery Procedures for Planning in Fabric IQ","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"4NG7Fx03M2Z5GuVum5XV","title":"CI/CD for Fabric Plan","pathname":"/resources/ci-cd-for-fabric-plan","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"HwXLrc3CeXdNHqg7ScVa","title":"Create and manage Home Layouts","pathname":"/resources/create-and-manage-home-layouts","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Resources","icon":"calendar-check"}]},{"id":"wnBedoa8RnY8CFYY4vOn","title":"Fabric Planning","pathname":"/video/fabric-planning","siteSpaceId":"sitesp_ofx2Z","description":"","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","description":"","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","description":"","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Planning"}]},{"id":"llMu9elrDf23AYeMxfgS","title":"Fabric Plan - Intelligence Sheet","pathname":"/video/fabric-plan-intelligence-sheet","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Video","icon":"play"}]},{"id":"m5HORDqtkRRPhqsMADHk","title":"Intelligence 301 - Fundamentals","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-301-fundamentals","siteSpaceId":"sitesp_ofx2Z","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"HJVPhPWB5GzyEZ3Moyfp","title":"Inside Explore Model","pathname":"/video/fabric-plan-intelligence-sheet/inside-explore-model","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"xidOpSM4pvZU6HwZJrg0","title":"Intelligence Sheet Interface Overview","pathname":"/video/fabric-plan-intelligence-sheet/intelligence-sheet-interface-overview","siteSpaceId":"sitesp_ofx2Z","description":"","breadcrumbs":[{"label":"Video","icon":"play"},{"label":"Fabric Plan - Intelligence Sheet"}]},{"id":"c1irKTto5xFPSeFc1p0m","title":"1 - Introduction to Plan","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","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","description":"","breadcrumbs":[{"label":"User Guide","icon":"book-open-lines"},{"label":"10 - Writeback"}]}]}