I’m created a google doc posted to the Canvas platform for individual students to record data from an experiment. (see below for screenshot img)
In excel, I can easily (1) insert AVERAGE formula for each row of data (2) protect all cells except for those where students entered data.
I need to embed that same data entry table from gSheets in a gDoc. However, when I copy the selected table cells from the google sheet, neither the AVERAGE formulas not the cell protection copy over into the gSheet.
Neither “paste table with link” to gSheet nor “paste unlinked” produces the desired results of (a) preserving the AVERAGE formula (b) cell protection. I can do without cell protection, but must have the average formula working.