Hello,
I am trying to help another teacher with Google Sheets. She is trying to do a sheet where when students complete work for the day she puts a check mark. She would like it to automatically fill a box off to the right for each subject if the students complete 4 of the 5 days of work. Each subject has 5 check boxes using true or false. One box is for each day of the week (M-F). She would like a code that if 4 of the 5 are completed it will then fill a box further to the right to show they got credit for the week in that subject. I put a document that allows you to copy the google sheet as an attachment.
I am not sure how to code each subject to get the end result that she would like. Would appreciate any help.
Bookmarks