Simple calculation on input table

I can't seem to make this work.  My ultimate goal is to have a table with 3 (or 4) columns: question; point value; user input value; calculated value.  (I don't need the Points for Each if I can put that value in the calculation).  Then sum all of ColD for Grand Total.  

Spreadsheet widget - I couldn't see how I could add the questions to ColA.

Input Table - Conditionals - I followed guide, but the values don't populate into D2.

If I enter values, the grand total doesn't get updated.

What am I missing/doing wrong?

I would suggest directly using the Form calculation widget to get the total for input box.

Go to your Grand Total Form calculation widget and select the fields to be multiplied.

You would have to add each table with a Form calculation widget.

Here is my sample form:https://form.jotform.com/90834977155974

Please give it a try and let us know if you have further questions.

So I can't use conditions to do it in the table?  I ask because I thought it looked better. And because I wanted to show the value for each Activity in the grid for running subtotal. (replacing a current form that is formatted this way)

Doing the way you suggest, I could just ask each question as a number and then use calculate on each answer field with the weights included in the formula.  (see updated form). I was hoping for a more elegant/concise display.

You may use conditions in the Input table.

Here is a guide:https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition

To clarify, do you want to pass the input table calculation to your spinner fields?

You may also assign values to your fields.

Guide:https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

Please give it a try and let us know if you have further questions.

I tried the conditions on the Input table and it didn't work (following the guide linked).  That was the screenshot from my first post. Can you see what I'm doing wrong? 

The demo wasn't working when I tried but it is working now so I'll clone that and try.

If I can do the calc in the Input table then I'd be happy. No need to carry it to spinner.  I would want to carry the table summed values to a Grand Total field.

I added the formula to the Calculation widget (Grand Total)

It is now summarizing the Total Points column of the Test table.

Ex:

Is this the calculation process you wanted to happen?

If not, please clarify and provide us with clearer details so we can review again.

Thanks for that.  What I was trying to do was update Total Points in the table on Number of Events entry using Condition.  It was not working, but now it seems to be working.  Looks like Privacy Badger did not like cdn.jotfor.ms (starting recently).  Thanks for the help.

Before Privacy Badger

After adjusting Privacy Badger

Thank you for sharing to us more details. From your latest response we assumed that all is good now.

Let us know if there is anything else we can assist you with