You can use a formula column to automatically calculate and display subtotals to bidders. For more information on building formulas, see the Cost Calculation section.
- Go to Design > Bid Sheet.
- Click the Columns tab.
- Click Add a column.
- Enter the column name in the Name field.
- Optional: Enter a column description in the Description field.
- Select the Calculate values with a formula checkbox.
- Click a Visibility option.
- Click a Formula type option.
- Optional: If you selected Feedback formula as the Formula type, click a Bid source option.
- Click a Result type option.
- Optional: If you selected Number or Currency as the Input Type, select the number of decimal points the entered values will round to from the Round values to list.
- In the Formula area, enter the formula in the Enter a formula field, or else use the buttons provided to build your formula.
- Click Test this formula to test if your formula is correct.
- At the top of the page, click Save changes.