top of page
How to link sheets to the Master Student Record sheet:
-
Open the students_master sheet
-
Add a new row to the sheet and fill in the data
-
For the Classes Done counting function use the following formula
-
=COUNTA(IMPORTRANGE("link to the student sheet", "Sheet1!B5:B19"))
-
To obtain the link to the student sheet, open the sheet the teacher sent you and copy the URL or click share and copy URL link
-
Past the link in between the "quote" marks inside the formula
-
Do not change the "Sheet1!B5:B19" data
-
-
For the Classes Done counting simply formulate the amount of classes minus the Classes Done eg. =15-D1
bottom of page