Mapping Variables

Most formulas will contain at least one variable (otherwise, the result will be the same for each row in the structure). These variables need to be mapped to attributes, which can be issue fields, progress, a hierarchical total, user properties, or another column.

As you write your formula, Structure attempts to map your variables to well-known attributes. If Structure is unable to map a variable, it will be marked with a red warning icon, and you will need to map the variable manually.

To map a variable – or to edit an existing mapping – click the variable's name in the variable list or in the formula and select the appropriate attribute from the drop-down list.

Naming Variables

Structure recognizes most standard and custom fields. The trick is to make sure you're entering their names correctly:

• For one-word names, enter just the field name: summary or priority
• For multiple-word names: remove all non-letters and replace any spaces with underscores: story_points
• Variable names are case insensitive, so story_points and Story_Points will both map to the same field.

For a comprehensive list of recognized variable names, see Standard Variable Reference

Additional Resources

• Standard Variable Reference
• Columns as Variables
• Formulas within Formulas