Spreadsheet widget to add condition

Hi - I was wondering if there is a way too change the pricing in my spreadsheet for a product if a certain quantity is ordered?

In the form I have put together the W/S is multiplied by the quantity and shown in the TOTAL column - for our Solar Tubes if 20 are ordered the price is $10 as a special.

Can I put a code in that when the Quantity column exceeds a certain number that then that number is multiplied by a specific amount such as the $10 instead of $11.72 which is the normal W/S?

I was wondering if there is a way too change the pricing in my spreadsheet for a product if a certain quantity is ordered?

Unfortunately, we cannot add conditions with the Spreadsheet widget.

The widget can only calculate the formula in the Spreadsheet.

Hope this information helps.

If you have further questions, let us know.

Thanks for getting back to me, is there any other widget that could possibly do that?

Hello @kclasson,

Unfortunately, we do not have any other widgets that can bring in data from a spreadsheet and calculate the data with the form conditions. As my colleague has mentioned, the calculations can only be done within the spreadsheet.

However, if you were to remove the spreadsheet widget, then you would be able to create calculations for your form using conditions or the Form Calculation widget.

Here are a couple of helpful user guides to assist you with this in case you need them: 

How-to-Perform-Form-Calculation-Using-a-Widget

How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

Please let us know if you have any further questions or concerns, we are always happy to help.