Overview

Use a pricing table to collect detailed pricing information directly within your questionnaire. Pricing tables allow you to define structured inputs—such as product names, quantities, and discounts—and apply formulas to automatically calculate totals.

This helps standardize responses, reduce manual errors, and ensure consistent pricing data across vendors.

A pricing table allows you to collect structured pricing information and automate calculations directly within your questionnaire. This helps ensure consistency and reduces manual errors in responses.

Add a pricing table question

1. Go to the Questionnaire tab in your project.

2. Select the section where you want to add the pricing table.

3. Click + Add New Question.

4. In the Type dropdown, select Table.

Configure table columns

1. Click Edit Response (gear icon) to open the table builder.

2. Update column headers:

   • Select each default header and enter a name (for example: Product Name, Price, Quantity, Discount).

3. Add additional columns as needed:

   • Use Insert Column Left or Insert Column Right.

Add calculation formulas

You can use formulas to automatically calculate values within the table.

Calculate row values

1. Select the cell where you want the calculated result.

2. Enter = to begin a formula.

3. Use cell references to define the calculation.

Example:

=(B2*C2)-D2

Add a grand total

1. Add a row at the bottom of the table (for example, Grand Total).

2. Use the SUM function to total a column.

Example:

=SUM(E2:E4)

Save the pricing table

1. Enable Column Editable for fields that respondents need to complete.

2. Click Save in the table builder.

3. Click Save on the question to apply changes.

Best practices

• Use Column Mandatory for required fields such as Price or Quantity.

• Include units in column headers (for example, Price (USD)).

• Preview the questionnaire to verify formulas calculate correctly.

Notes

• Formulas follow standard spreadsheet syntax.

• If a formula returns an error, verify that the cell references match the correct row and column.