I am working on a Google Sheet to pair with Autocrat in order to create a report based on entries into a Google Form.
The workflow will be:
1. Evaluator enters in scores in Google Form (the rubric)
2. Scores auto-populate in Google Sheet linked to form
3. Autocrat Add-On generates document report of scores per entry
There are some unique constraints in the scoring, though.
For each "Area," we take the "best of two scores."
For the FINAL score, we take the "total of the best of 3" out of the 4 areas.
For that cell, I am using
I finally figured out the "final score" formula, but I need it to be an array formula and auto-populate into all cells in that column. Dragging down to autofill does not work because when a form entry goes into the spreadsheet, it creates a new row above the existing ones, so the formulas won't be present without an array formula.
AC3 is the sum of the total of the 3 largest scores between K3, R3, W3, and AB3.
I need AC3 to be an array for the rest of AC, just as I've done in K, R, W, and AB.
Also, this will not let me attach a link or screenshot of the Sheet...
Bookmarks