Conditional Logic FAQs and Best Practices
This Help Article Appears in the Following Learning Tracks
Here are some tips for using conditional logic in Smartsheet forms.
When I try to save a logic rule, I see the following error message: “Sorry, there was a problem saving this logic. Logic statement is too large. Try reducing the conditions for the affected fields.” How do I avoid this error?
When creating logic within a field, you may be limited by:
- The number of rules you add to the field
- The length of the conditions in those rules
- The number of target fields that those rules apply to
To avoid the error, you may need to limit one or all of the above. Try using the following strategies to do so:
Use nested logic to spread logic rules across multiple source fields
If you experience the error in a field that has several rules which apply to several target fields, consider moving some of the rules to a different field which is logically downstream. For example, instead of configuring the logic for Field A to display Field B and Field C when conditions are met, try configuring the logic for Field A to display Field B, and the logic for Field B to display Field C. This is called nested logic.
Since a target field can also be a source field for additional logic rules, you’ll reduce the number of rules and target fields you add to any single source field when you spread your logic out across multiple fields and expand your form incrementally.
Select the most efficient operator
If you experience the error in a field that has large or numerous rules applied to a common target field, consider revising the logical operators you’ve used to ensure that you’ve created the most efficient rules possible. For example, instead of creating several rules that use the is operator with different values from the same dropdown field, try creating a single rule that uses the is any of operator. Similarly, if the target field should be displayed when the source field value is any of several values, consider whether the rule could be shortened by displaying the target field when the source field value is none of just a few values.
When you have fewer and shorter rules in your source field, you are less likely to encounter the error.
If a field on my form is the target field for multiple rules, when will it be shown?
When multiple rules are applied to the same target field, it will be shown when at least one of the conditions are met. Hover over the logic icon next to the target field to view all conditions that can result in its being shown.
How does conditional logic work on a multi-select dropdown?
When you use the has any of operator, the condition will be satisfied and the target field(s) will be shown when at least one of your specified dropdown options is selected. There is no need for the form user to select all of or a specific combination of your specified dropdown options.
When you use the has all of operator, the condition will only be satisfied when all of your specified dropdown options are selected by the form user. If the form user also selects other options that you did not specify, the condition will still be satisfied.
When you use the is exactly operator, the form user must select all of your specified dropdown options and no other options in order to satisfy the condition.
When you use the has none of operator, the condition will be satisfied as long as the form user does not select any of the dropdown options that you specified.
How do I conditionally hide fields on my form?
Your conditional logic rule will only display a target field if the condition is satisfied, meaning that the target field will be hidden whenever the condition is not satisfied. As a best practice, we recommend using your logic rules to expand your form incrementally rather than hiding fields in the middle of filling out the form. This will reduce the chance hiding fields that someone has already filled out.
If a field is not displayed, what does the data look like when the form is submitted?
Only the data from the fields that are visible at the time of submission will be submitted to the sheet, leaving the other cells blank.
Only the fields that are visible at the time of submission are included in the submission confirmation email.