top of page
How to link sheets to the Master Student Record sheet:

>

>

How to link sheets to the Master Student Record sheet:

  1. Open the students_master sheet

  2. Add a new row to the sheet and fill in the data

  3. For the Classes Done counting function use the following formula

    1. =COUNTA(IMPORTRANGE("link to the student sheet", "Sheet1!B5:B19"))

    2. 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

    3. Past the link in between the "quote" marks inside the formula

    4. Do not change the "Sheet1!B5:B19" data

  4. For the Classes Done counting simply formulate the amount of classes minus the Classes Done eg. =15-D1

bottom of page