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

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

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)

more website options for table block like formulas

Option to divide in pricing table (10/2=5)