undefined - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration 06a6cdda-2e0c-4345-a3de-6be30f5393ad

Using Values from a Spreadsheet in a Price Table

If the price of a product or service relies on a formula such as in Progressive Pricing or Bracket Pricing, the value/price from the specific formula can be reflected in a price table line item by creating that formula in a spreadsheet content block (which can be hidden or seen by the sales quote recipient).

This user guide explains how to link a price line item to a cell in a spreadsheet.

To begin, first, start by editing or creating a sales quote and then insert a Spreadsheet. You can do this by clicking on the + button and selecting Spreadsheet, as shown below.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration 47b4c196-e130-43b6-a789-4409e28f1da1

A new spreadsheet will appear and can be edited.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration ac469708-d6c3-4dcd-b076-c110b4efb6da

Next, add a Price Table by clicking on the + button and selecting Pricing Table, as shown below.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration 387b7c4f-1d9a-40b9-ba6e-7723d3a58a69

To show the price item line options, hover over the price item and click on the three dots to the right of the row.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration 88f6d0ae-a50d-4b0f-97ac-6fe8e3868924

Further options will then be displayed once you click the three dots. Select Options.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration c81509cf-dbf4-4854-b77c-4e26d5e2e434

A window titled Line Item Options will pop up.

Type the command to link the price line item to the spreadsheet in the Price from a Spreadsheet input field. In our example, we have typed $VALUE{Sheet2:C1}, as shown below. Save your settings.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration c1143b3e-c063-48ff-8316-5dbdc5b8ad27

To link the price of this price line item to a value in a cell of a spreadsheet, we need to create the reference to the Spreadsheet Name and the exact Cell in that spreadsheet. For example, if the spreadsheet name is "Sheet 2" and the cell we would like to reference is C1, the command to type in the Price from a Spreadsheet input field is $VALUE{Sheet2:C1}.

The spreadsheet name is located in the top right corner of the spreadsheet content block, as highlighted in the image below.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration 739e9632-1fb6-43c6-9e1a-f475e7e0a5e5

The value from the spreadsheet will now display in the price table.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Getting Values from a Spreadsheet to use as a Price in a Price Table - illustration c918835d-7115-4f34-9811-53954a3d4f0a

Related User Guide Topics