Can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?

Similarly: can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?

Yes, it is possible to integrate your form with Google spreadsheet. So that when you submit your form the information will be added to a spreadsheet. And it is easy to accomplish too. Simply follow this guide:

How to Integrate Form with Google Spreadsheet

 

However, all fields on your form will be inserted into your spreadsheet

So if you want to capture only one field, this is not possible. Instead, you should hide the columns you dont want to see within your Google spreadsheet.