Posted 8 September 2017, 1:19 pm EST
Hi! I'm not sure as to what subject will i put for this new post. I get this strange behavior to my other sheets except the first one sheet. I generated my sheet programatically.
This is what's happening. I typed Assign number of item and Score of students. I have a formula to sum up all the assign number of item as well as the total score of the students. I have set autocalculation to true. It works fine for the first sheet but when i do the same for the rest of the sheets it's not autocalculating. It will only calculate when i press the up arrow key and the strange thing is the sheet creates new row and duplicates the name of the student where i entered a the score or item. why is this so?
Please see the attachment for a more detailed behavior of the sheets.
By the way, i tried this with two students only for purposes of checking if my formula works.