SERVICES
Tutoring
Education Planing
Campus Tour
English On Site
COMPANY
About Us
Contact Us
COMMUNITY
Website
Creativities
Study Overseas
Home School
THE BUDDY EDUCATION STUDIO
Let's Design Your Own Future
Mentoring you to success and unleashing  your true potential

2018 THE BUDDY KIDS KNOWLEDGE DEVELOPMENT CO., LTD. ALL RIGHTS RESERVED

>

>

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