How to add spreadsheet fields to form calculation?

Unfortunately, we cannot add conditional logic with the Spreadsheet widget.

Please share with us details of your requirements so that we can look for other alternatives or workarounds.

Looking forward to your reply.

I am wanting to add the total fields from the spreadsheet into the calculation field. 

See form elements below

Hi,

You cannot pass the value from spreadsheet widget to another field, but you can calculate the total

from within the widget:

C3 = c1 +c2 gives you the sum of total.