I'm working in behavioral analysis and trying to implement a formula the would track and automatically update the number of behaviors per time period. We track the 10 previous days, which gives us insight into our mastering and fading processes. I began with conditional formatting for anything less than 1= green, anything more than 1=red. This collects data from another excel sheet, but I just would like it to automatically update for me if possible. Thanks!
I've used google quite a bit and found one similar post referencing tracking data for the previous two weeks. I'm not very good with sheets, so I've tried to copy and paste, but it is not working. This is the closest that I have found Finding the average from the last 14 days in Google Sheets
Ideally, I will be able to keep track of how many are happening per time period. Ideally, it would update automatically and tell me how many per time period for the previous 10 days.