Merge Tags Calculations

You can select the Merge Tags List (Column sum) and List (Row count) from the dropdown:

• List (Column sum): Calculates the total of all numbers in one or multiple rows together.
• List (Row count): Counts the number of rows.

It is also possible to type the merge tags manually using this format:

• {list_field_label:field_id:column_number} -> (Column sum)
• {list_field_label:field_id} -> (Row count)

See examples below. You can also use these Merge Tags on other places, like in the notification, GravityView or Workflows.

Try a single column list field. For the calculation in the Number field ‘Column total’ the following Merge Tag is used:

{List:1.1}

For the Number field ‘Total number of rows’ the following Merge Tag is used:

{List:1}

Multiple columns

With a multiple column list field, you get calculation Merge Tags for every column separately. For the calculation in the Number field ‘Column 1 total’ the following Merge Tag is used:

{List multiple columns:7.1}

Explanation of the merge tag structure

In the merge tag {List multiple columns:7.1}, the “7” represents the specific field ID of the List Field you are working with in your Gravity Form. Each field in Gravity Forms has a unique ID, and this ID is used in merge tags to reference that particular field.

If you are referencing multiple columns, you use the specific column number following the field ID, separated by a period. In this example, “7” is the field ID, and “.1” specifies the first column within that List Field.