Check Box and Toggle Columns on Modeled Sheets

We now enable you to use check box and toggle columns in Excel Interface for Planning without having to purchase Sales Planning. When you add a Checkbox data entry column in Model Administration and configure it, we display the column on your Excel Interface for Planning sheet after you load the sheet.

We now enable you to add a Checkbox data entry column on your modeled sheets without having to purchase Sales Planning. When you add a Checkbox data entry column in Model Administration and configure it, we display the column on your modeled sheet.

This enables you to enforce consistent values and create more dynamic models that drive calculations on whether or not you select the check box.

Example: You can create a formula where if(checkbox.column=1, use one calculation, and if checkbox.column=0, use another calculation). This enables the model to present different values on row details based on whether or not you select the check box.

See Add Check Box Columns to Modeled Sheets.

You can now only enter a 0 or 1 in check box and toggle columns on your Excel Interface for Planning sheets. You can either leave the cell blank or enter:

0 for off.
1 for on.

This enables you to enforce consistent values and create more dynamic models that drive calculations on whether or not you select this check box. Example: You can create a formula where if(checkbox.column=1, use one calculation, and if checkbox.column=0, use another calculation). This enables the model to present different values on row details based on whether or not you select the check box.

We don't automatically change any existing check box and toggle column values on your Excel Interface for Planning sheets. We continue to display your modeled reports whether or not your check box and toggle column values follow this new restriction.

When you upload modeled sheets in Model Administration, you can now only upload a 0 or 1 in check box and toggle columns. You can either leave the cell blank or upload:

0 for off.
1 for on.

This enables you to create enforce consistent values and more dynamic models that drive calculations on whether or not you select this check box. Example: You can create a formula where if(checkbox.column=1, use one calculation, and if checkbox.column=0, use another calculation). This enables the model to present different values on row details based on whether or not you select the check box.

We don't automatically change any existing check box and toggle column values on your modeled sheets. We continue to display your modeled reports whether or not your check box and toggle column values follow this new restriction.

See Spreadsheet Import.