How to copy values from spreadsheet widget?

Can I populate a text field with a cell from a table in the form? For example make text field 1 = cell r1,c-foundation

https://form.jotform.com/92145928267163

Unfortunately, it is not possible to fetch the specific cell in the Spreadsheet widget using form calculation and conditional logic. 

However, you can use the "Input Table" widget to replicate the behavior in the Spreadsheet widget, you just need to use Conditional Logic to calculate the values in the cell. Then you can simply fetch the cell that holds the total calculation in the "Input Table" and insert it in a Form Calculation widget. 

Following help guides explains you on how to accomplish this:

https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field 

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

I hope this helps. Feel free to get in touch should you have further concerns.