I’m trying to work on some data from a Google sheet that we’re sending feedback to.
We have two columns in the sheet:
rating | submitted at
ie. 4 | 2020-12-13
So every Monday morning I’d like to take only the rows submitted in the last 7 days, run some math on it, and post those results in a slack channel.
Now, I’ve tried using the filter method to do that, but I can’t get that to filter out based on dynamic dates like “Last 7 days”.
Anyone knows of a solution to this?