Skip to main content

Adding a formula column to your bid sheet

  • Updated
Follow

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.

  1. Go to Design > Bid Sheet.
  2. Click the Columns tab.
  3. Click Add a column.
  4. Enter the column name in the Name field.
  5. Optional: Enter a column description in the Description field.
  6. Select the Calculate values with a formula checkbox.
  7. Click a Visibility option.
  8. Click a Formula type option.
  9. Optional: If you selected Feedback formula as the Formula type, click a Bid source option.
  10. Click a Result type option.
  11. 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.
  12. In the Formula area, enter the formula in the Enter a formula field, or else use the buttons provided to build your formula.
  13. Click Test this formula to test if your formula is correct.
  14. At the top of the page, click Save changes.