https://docs.google.com/spreadsheets/d/1oWXZYCoKK_dqu8ONcTGqOU4pNBlypi3X7ES7uH7vcNQ/edit?usp=sharing (Disclaimer: First time ever using Sheets/Forms and I am not great with Excel Either)
I have a Google Sheets file that takes all the responses from a google form and sorts them by foreman name. I am running into a problem however. The formula I have used seems to work and then when I close the sheet and open it the next day it keeps moving the cell range down to the line right below the data. This is the formula I am using
=FILTER('Form Responses 1'!$A$2:BE,'Form Responses 1'!$BE$2:BE="William Kirby")
I tried to use $ like in excel to lock that range but I don't think its working. I just went back through and changed them all to what they should be again, but I need that formula to stay what it is at all times. I left the last foreman on the list wrong so you could see what it changes to. His name is Zach Habron.
Any advice would be much appreciated