Required Columns on Modeled Sheets
We now enable you to require specific columns on modeled sheets, helping to ensure that the plans contain all the data you need to accurately budget and forecast.
To enable required dimension column you must submit an Account provisioning ticket.
Required
Column Check Box
Required
Column Check Box
Release: 2021-03-12
We provide a new Required Column check box in the General Properties section of custom dimension columns when you maintain modeled sheets, enabling you to configure which columns are required.
Also, when you use the sheet in the Sheets section, we highlight rows containing an empty required field. For
Excel Interface for Planning
, we don't:- Highlight rows that contain an empty required field.
- Require columns when you add new rows.
We also don't require columns for manual imports and integrations.
Required Modeled Sheet Columns in APIs
Release: 2021-03-12
A new requiredColumn attribute for Dimension tags indicates when a modeled sheet column requires a dimension value selection before users can save the sheet. This attribute becomes available in API v27 for:
- importModeledSheet
- exportModeledSheet