Ability to add formulas to tables in PandaDoc templates

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.

A standard table that mimics excel for building an employee expense report in forms

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)

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.

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.

I assumed this would be core product. Can you not create basic formulas in pricing tables? That is strange

Yes - Formulas would be a game changer

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.

Yes please! Formulas!

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).

Add simple formula ability in table cells using data from other cells, or referenced cloud based csv files. (+-*/)

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

Can have the pricing table compute in different columns just like the way excel does?

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!

Yes yes please.

need advanced macro equations, similar to excel

Yes please! We bill our users monthly and would appreciate having a row for "Duration (Months)" and "Monthly Total" (subtotal/Duration).

YES PLEASE!! This is so important and an obvious helpful feature for all! I want to be able to set a total, and then set a breakdown of payment terms of that total. ie. 25 up front, 25 on start, 25 progress pmt, 25 on completion. it should auto calculate these amounts but instead I have to rely on a separate calculator and manual input leaving room for error!

Hello,

I think it will be an extremely useful tool for all kinds of businesses to be able to apply mathematical operations to price tables. I mean the simplest ones (addition, subtraction, multiplication, division).

The mechanism can work very similarly to excel table - take the value of column X, add Y and divide by Z (Example attached)