Sheets 4 Schools

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.

My coding club has a spreadsheet of student accounts. Each account needs me to make an individual email address. Fortunately, they all follow the same pattern firstname.lastname@ymca.ca The first formula I tried was TEXTJOIN.  This formula  = TEXTJOIN ( "." , TRUE , A141 , B141 , "@ymca.ca" ) , gave me the following. Firstname.Lastname.@ymca.ca Then I needed to change the capital letters to lowercase, so I used the LOWER function, = LOWER ( I139 ), which gave me firstname.lastname.@ymca.ca Looking for a way to remove the period after "lastname", I tried the SUBSTITUTE function, = SUBSTITUTE ( I140 , " " , "." ), which gave me the following result. firstname lastname @ymca.ca Frustrated, I Googled the answer. SOLUTION The CONCAT function. Solution Page

I teach a coding course where some of my lessons have combined classes come to me. We recently had some new students and I wanted to see what the updated number of students in the class would be.  I started by simply adding the numbers. I found that you can hold CMD and click on all the cells and Google Sheets will automatically give you the sum of the numbers. But what happens when students enter or leave the school? I have to manually update my sheets.  Fortunately, I have access to the main spreadsheet with the class numbers.  Since I want an up-to-date sheet, I knew I could use the IMPORTRANGE function to get the information. Then I needed to add them together using the SUM function.  The final formula looked like this below. = SUM ( IMPORTRANGE ( "sheetURL" , "Sheet!C28:C29" ) + IMPORTRANGE ( " sheetURL " , "Sheet!C30:C31" ) )