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?
Thank you!
Welcome to the community!
Try using a Compare dates step after pulling in your data from Google Sheets. By default, this step creates a new column called Difference and finds the number of Hours between an auto-selected column.
Just be sure to select the number of Days between your submitted at column and the current time.
Using a Filter rows step, you can keep rows that have a value less than or equal to -7 in the Difference column.
Sounds like that should do it. Ill try that and let you know Daniel!
