Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Modeled Sheet Data Validations

Modeled Sheet Data Validations

We continue to enhance your ability to use data validation rules for user-entered data on modeled sheet cells, enabling you to filter for rows that violate your validation rules. This makes it easier and faster to correct invalid data.

Display only rows with data validation errors Check Box

Release: 2024-03-09
We add a new Display only rows with data validation errors check box on the Display Options of your modeled sheets, enabling you to filter for rows that violate validation rules set up by your model administrator.

Clone, Download, and Upload Modeled Sheets

Release: 2024-03-09
When you create new modeled sheets in Model Management, we now include validation rules when you:
  • Clone an existing modeled sheet.
  • Download a modeled sheet, edit that file, and upload a new modeled sheet using that file.

Scenarios in APIs

Release: 2024-03-09
The exportVersions API enables you to set a Boolean scenarios attribute in the include element of requests to return scenarios in the response. The response body indicates type="SCENARIO" for scenarios.
You must use API v37 or higher.

Type Prompt for Validation Logic

Release: 2024-04-12
When you create or edit a rule for your modeled sheet in Model Management, we add a new Type prompt that enables you to select whether the validation displays an error when the data either:
  • Meets the conditions of the rule.
  • Fails the conditions of the rule.
See Set Up Modeled Sheet Data Validation Rules.

Rename Prompts in the Create and Edit Rule Popups

Release: 2024-04-12
For clarity, we rename these prompts when you create or edit data validation rules for your modeled sheet in Model Management:
  • Rule Name to Name.
  • Validation Expression to Expression.
  • Validation Help Text to Help Text.
We also update the hover text for the Action prompt.

Maximum 10 Active Validation Rules

Release: 2024-04-12
Instead of restricting you to a maximum of 10 validation rules, we now enable you to have up to 10 maximum active validation rules.

Data Validations on Sheets Created by Planning-Only Workforce Planning Configuration Managers

Release: 2024-04-12
We now enable you to use data validation rules on sheets that you created using a workforce planning configuration manager with the Plan in Adaptive Planning purpose.