Required Columns on Modeled Sheets
We now automatically deliver the ability to use required columns in modeled sheets. You no longer need to request this functionality.
You can't use this feature when you use the Excel Interface for Planning (EIP) functionality.
Required Columns Setting
Release: 2021-09-11
We deliver a new Required Column check box in all custom dimension column settings on the modeled sheet administration page.
Required Column Indicator in Modeled Sheets
Release: 2021-09-11
To make it easier to identify required columns, we now:
- Display a red asterisk in the header of required columns.
- Highlight the cell when it's missing data.
Modeled Sheet Data Import Required Columns
Release: 2021-09-11
When you mark a column as required, we now display the column in the mandatory columns section on the import file.
View Modeled Sheet Required Columns in EIP
Release: 2021-11-12
We now enable Excel Interface for Planning (EIP) users to view required columns in modeled sheets on both desktop and EIP. We also now display an asterisk in required columns on both desktop and EIP. This enables sheet viewers to know where they must enter data before saving the sheet.
When a user doesn't populate a required column, we display an error and navigate them to the specific column.