close

Using Values from a Spreadsheet in a Price Table


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.

 

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.

In the sales quote editor click on the orange + Insert button and then select Add Spreadsheet, as shown below.

A new spreadsheet will appear and can be edited, as shown below.

Next, add a Price Table.


Click on the + Insert button and select the option Add Pricing Table, as shown below.

Add a price line item to the price table.

Click on + Add Price Row in the price table, as shown below.

Now, to begin using values from a spreadsheet in a price table, click on Actions button located on the far right hand side of the price row.

This will show a dropdown menu, select Options.

A window titled Line Item Options will now appear.
 

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 1" and the cell we would like to reference is C1, the command to type in the  Price from a Spreadsheet input field is $VALUE{Sheet 1:C1}. 

NOTE: the spreadsheet name is located in the top right corner of the spreadsheet content block, as shown below.

 

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{Sheet 1:C1}, as shown below.

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

Related User Guide Topics

Price Table Settings - Hide Qty 0 (Zero) Price Line items
27 Mar 2021
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. 
Grouping Price Line Items and Summarising (Hiding) up to a Subheading
13 Mar 2021
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.
Adding a Subtotal to a Price Table
13 Mar 2021
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.
Getting Values from a Spreadsheet to use as a Price in a Price Table
12 Mar 2021
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.

Getting Started

QuoteCloud 2013-2021 Copyright all rights reserved