Currently, I have an existing spread sheet (similar to excel) created using Google Sheets. In this sheet, user would manually input data into cells. There are some functions in this sheet to calculate some basic functions like sum, average...
I would like a form to be created based on this existing Google Sheet. Users would enter data through a GUI form, instead of Google Sheet Cells.
Must use Google Apps Scripts
Must be compatible with Google Sheets and Google Drive
Form must collect data (about 12 to 15 cells) from users and paste to existing Google Sheet
Buttons on this GUI form to show Total Sums, Averages, and Graphs
All functions, calculations, and graphs are already on this Google Sheet