Sheets 4 Schools

To be honest, I don't know the proper terminology. But, after spending about 4 hours working on this formula, I got it working. The problem I was trying to solve was that we had a spreadsheet that was being updated regularly with data, and we wanted to feed that data into a different spreadsheet.  I knew that. I could simply do this with IMPORTRANGE , which can get the data for each cell, but then I would have to create a formula for each entry. I wanted a single formula that matched the student name to the data. I knew from past projects that the INDEX and MATCH combination was probably something that I wanted to use. So I started playing around with it.  Student Name student ID gender grad year current grade DOB RTI reading level The particular data I wanted was the reading data.  In the end, ChatGPT helped me figure out that the formula would be something like the following. = VLOOKUP ( A7 , IMPORTRANGE ( "URL" , "SHEET!RANGE" ) , data COLUMN , FALSE )

Made with Craiyon

One question we received from the last Tech PD was about where to learn more about Google Sheets. Here are a few resources. Ben Collins - Google Sheets Training [Courses] Ben Collins is a data analyst who is also a certified Google Expert. (That's the actual badge name from Google.) He has several courses, most of which are paid, but check out the Advanced Formulas 30-Day Challenge, which is free. Learn Google Sheets [Channel] This is one of my favorite Google Sheets-related channels on YouTube. There are a range of videos here from beginner to expert. Google Sheets - Full Course [Video] An in-depth video all about Google Sheets. It is 3 hours, but there are chapters so you can jump around. Google Sheets Advanced Tutorial [Video] Another video lesson. This one is for users more familiar with Google Sheets. If you just need an assistant ... Excel Formulator [Website]  This site allows you to type in what you want to do, and the AI will generate a formula for you.  via Shukesand

I am trying to put together a sheet for tracking student scores based on criteria. I have made checkboxes (that work!) that when checked, give the averages of criteria.  My next step is to make a formula that will gather all same criteria as the row in the checkbox and average them from that point.  I have the formula that will get the minimum date and the matching criteria to that date. From here I need to figure out how to get the average of all criteria in a date greater than the date from the box that is checked.

I created a chart from some data. Gridlines would definitely help to make it easier to read, but a label would be even better.  To add a label, go into the chart editor and click on Customize in the top menu. Then scroll down to Series . In the Series menu towards the bottom are three checkboxes - the last one is Data labels . You might need to change the format.  Click on the drop down menu and select from source data .

Sometimes there are sheets that you want to share, but maybe some of the data needs to be fixed.  This is when protecting cells can help.  To protect a cell or a range of cells: 1. Highlight the cell or cells and select the DATA menu. 2. In the DATA menu, select, Protect sheets and ranges 3. In the menu that appears on the right, enter a description. In my example, I wrote a message for whom to contact for editing rights. 4. You can also change permissions and add a warning when clicking the cell. You can also add collaborators who are able to edit the data without a warning. To do this click the Change permissions  button below the range. After clicking Change permissions, this pop-up appears. 5. To delete a protected range, open the right-side menu again by clicking on DATA and Change permissions .  Click on the trash can.