Pricing Table calculations: Excel Formulas.
Enable much higher flexibility in the Pricing Table with Excel-like formulas that allow summing up the columns you like or aggregating a total based on custom rules.
![](https://secure.gravatar.com/avatar/3b5e5b5e3d7eed74744979f1835aafe9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Hi,
Good news: we have already started working on this feature, and it will be ready for Early Access soon. If you'd like to test it, please fill out this form: Quote Rules and Formulas
-
Allie Brittain commented
Our product pricing is quite extensive and clients only need to see the summary.
I'd like to create a table that shows:
1) one time costs
2) annual sum of annual costs
3) annual sum of monthly costs
4) year 1, year 2, and year 3 totals -
Angelica Lapat commented
For example, if we wanted to get an annual amount value derived from the price table's total. We can use the total * 12 and place it into a variable.
-
Paul Rosa commented
This is very important for price table. It will allow to make different calculations based on quantities, discounts and price
-
AdminYana Martynenko (Admin, PandaDoc) commented
Smart tokens
1) the token that illustrates the price of a specific product;
2) Can plus to each other and sum up to be the same as total amount in the pricing table. -
Savannah Faulkner commented
Calculation for custom fields (added from catalog) in a pricing table or quote builder
-
Alison Henry commented
Our team is looking at other contract solutions that can support this. It is absolutely critical but does not seem to be moving forward.
-
Khurram Nazir commented
A must have for the business, please add asap.
-
Jason Morriss commented
Please add functionality to record deposits or partial payments and a resulting final balance. This could be accomplished with formulas, but making it standard would be great
-
Connor Smith commented
This would improve efficiency for us.
-
Lucidity Sales commented
Please allow variables in pricing tables as a bare minimum. We need to be able to add up individual tables into an executive summary.
-
Joris de Boer commented
Simple formulas in a pricing table would be absolutely a big plus.
-
Red Safety commented
I'm looking for this as well. Just saying!
-
Alison Henry commented
This is so critical for so many. Please add soon
-
Andrew Campling commented
Is there any timescale on this, since I voted last year is gathered a good deal of momentum, topping 500 votes. Please PandaDoc, get this sorted, it's a massive time saver and I'm sure would help all your users generate more business.
-
Geoff Meczka commented
The current functionality of the Pricing Tables and Advanced Quotes is a big let down. There are far too many limitations.
The advanced quote tables take up far too much page space when presenting multiple items to a client. What should be a 1-2 page document turns out to be 7 when using advanced quotes.
-
Anonymous commented
add a formula to pricing table where the price per item changes as the quantity goes higher
-
Paul Cedric Guevarra commented
Option for the user/sender to divide, add, subtract,multiply qoute/pricing table totals
-
Ernie de Wal commented
If this is under development there should be the ability to determine the number of columns desired, the headings to be assigned to thee columns AND ensure that this is API accessible.
-
Andrew Arbuckle commented
It would be good to hear some feedback from Pandadoc if this will ever be on the roadmap? Its been a top rated idea for along time. the ability for some very simple calculations from document value would save hours of work a week for my team.
-
Angelica Lapat commented
The ability to put a cell in the pricing table to take a percentage of another number in the pricing table