I have a sheet that is updated daily. I am trying to create a report that shows the previous 7 days worth of entries. I could not figure out how to do this so I created a helper column that checks a box for items that have a date up to 7 days prior to TODAY. However, if I don't do into the main sheet every day and save, the checkboxes don't automatically update to the last 7 days entries. Is there another way to set up the report so it's updating automatically?
Help Article Resources
Check out the Formula Handbook template!