undefined - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration 06a6cdda-2e0c-4345-a3de-6be30f5393ad

Using Values from a Spreadsheet in a Price Table for a Price Line Description

When using a spreadsheet to calculate a price of a product or service, it might also be useful to set the price line description from the spreadsheet.

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

Start by editing or creating a sales quote and then inserting a Spreadsheet. In the sales quote editor, click on the + button and select Spreadsheet, as shown below.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration 429a617e-1673-4517-a91c-2f1a5045043b
A new spreadsheet will appear and can be edited.
QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration c5e4e14e-0c70-4e53-bd0e-72dc9ccc1f70

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 - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration 6cf9886b-8eb6-42ed-ba82-942760303753

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 - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration 31faa59c-9c25-4079-83b4-5f131b997af7

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

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration 82d6fc66-c618-4d95-9502-65e0168f37b9

A window titled Line Item Options will pop up.

Type the command to link the price line item to the spreadsheet in the Description 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 - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration fc1d0c53-e430-4a72-9673-305eb4e6079d

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 B2, the command to type in the Price from a Spreadsheet input field is $VALUE{Sheet2:B2}.

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 - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration ae7943cb-6ca9-4192-9b95-76ff3957ea33

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

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Using Values from a Spreadsheet for a Price Line Item Description in a Price Table - illustration b93573d8-e467-4ca3-a0b6-73cdb5a0cc11

Related User Guide Topics

Using Values from a Spreadsheet for a Price Line Item Description in a Price Table
Using Values from a Spreadsheet for a Price Line Item Description in a Price Table
12 Mar 2022
When using a spreadsheet to calculate a price of a product or service, it might also be useful to set the price line description from the spreadsheet also. 
Adding a Subtotal to a Price Table
Adding a Subtotal to a Price Table
12 Mar 2022
This user guide explains how a Sales Consultant can add price line items to a sales quote price table and then group price line items to summarise up to a sub-heading.
Grouping Price Line Items and Summarising (Hiding) up to a Subheading
Grouping Price Line Items and Summarising (Hiding) up to a Subheading
12 Mar 2022
This user guide explains how a Sales Consultant can add price line items to a sales quote price table and then summarise these price lines up to a subheading, hiding the price line items and showing the total of the grouped price line items at the sub-heading level.
Price Table Settings - Hide Qty 0 (Zero) Price Line items
Price Table Settings - Hide Qty 0 (Zero) Price Line items
12 Mar 2022
There are use cases where a price table is created as part of a sales quote template and preloaded with price line items, when the sales quote template is used to create a sales quote, the sales consultant simply removes unwanted price line items and adjusts the quantity to order for the sales quote recipient requirements. 
Getting Values from a Spreadsheet to use as a Price in a Price Table
Getting Values from a Spreadsheet to use as a Price in a Price Table
12 Mar 2022
If the price of a product or service relies on a formula, this can be achieved in QuoteCloud by creating that formula in a spreadsheet content block (which can be hidden or seen by the sales quote recipient).  A price table line item can then get its price from a cell in that spreadsheet.
Allowing Recipients to Choose Price Options
Allowing Recipients to Choose Price Options
12 Mar 2022
If you would like your recipients to be able to choose among different options within the pricing table, you can set line items as optional.