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.
AdminAnonymous (Admin, PandaDoc) commented
advanced calculations/ cpq - divide by month the price for each product line item in the pricing table
Paul Cedric Guevarra commented
Formula option for Tables
Jeff Rosen commented
Excel formulas being possible within PandaDoc Tables. Specifically, a sum formula and one for percentage increases/decreases would be ideal.
Andrew Arbuckle commented
Top 3 Idea from 2 years ago (and a critical one) and still just an idea...
Emily Gould commented
Ability to add formulas to tables in PandaDoc templates
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.
Shawna Stewart commented
A standard table that mimics excel for building an employee expense report in forms
Mauro Gesti commented
Improve general management of SKU in the catalogue.
The present catalogue is too basic.
1. Organize SKU/Catalog Items packages into lists/membership lists to offer a complete SKU package. That is to be able to import in a single stroke in a pricing table more SKU that I belong to a package composed from more SKU.
2. insert a function that allows you to edit the data of the SKU of the catalogue directly from Pandadoc without having to export to a CSV file and then having to import them back into the catalogue in Pandadoc. By doing this operation sometimes imports do not work well in converting CSV to Excell and you risk losing data or damaging it. It would be more useful a mass modification function of the articles of the catalog (how to increase all prices by a certain percentage)
Arvi Martinez commented
a pricing table whereby the user is able to enter a quantity and the rate charged per quantity will automatically update based on quantity selected.
David Marsh commented
This would definitely help to streamline contracts by allowing the client to choose their price using a calculator.
I would like to see the client choose the service location, the term of the agreement, the number of widgets, other widget options that would change the product SKU, the description, and their monthly/yearly pricing.
Kevin Lee commented
I assumed this would be core product. Can you not create basic formulas in pricing tables? That is strange
Ashley Dadd commented
Yes - Formulas would be a game changer
Solomiia Mereniuk commented
should be possible to do a field a formula? For example, I want to do a formula that shows the dollar amount of our seasonal discount that is a % of another field.
Peter Hiebert commented
Yes please! Formulas!
Yan le Luyer commented
Yes! In my propositions, on the last line of a Pricing table I manually subtotalize all upper lines costs, and then apply a production fee multiplying this global subtotal by a %.
But if I authorize options boxes by clients, my production fee line will not be updated.
It would be great to have a bottom line option, offering a formula like : =sum(above.section.subtotals)*[%multiplier.column).
Bruce Fillmore commented
Add simple formula ability in table cells using data from other cells, or referenced cloud based csv files. (+-*/)
Nick Rivero commented
Hey all! Some Basic formulas in tables would be great, much like Excel and Google. I know this has been requested for Pricing Tables, but this would also be useful for standard tables.
Example: I would like to calculate a series of dates based on a starting date.
Date 1 + 7 days = Date 2
Dates, Numbers, Time of Day would all be useful
Ivy Leow commented
Can have the pricing table compute in different columns just like the way excel does?
Andrew Arbuckle commented
This is a must!! I waste so much time manually typing out loan repayments in each document, this would save me hours of work every week!
Michael Knill commented
Yes yes please.