I love you guys - as you are all always so helpful. SO, I am using autocrat to email my students their final score from a project. The merged letter works great, but it just will not pull in the final score column automatically. In my final grade column I have an =sum formula that is adding up the numbers from the various criteria in the Google Form. I dragged the formula down the entire column, but it seems whatever my final question is, the words "spill over" into the next adjacent cell, which makes the formula disappear. Any ideas?
Photo
Shared publicly