Google Sheets Code

Questions
,
1

So in my Google sheet I have a column that says “Last Updated” and in the rows under it, it has the formatted date (yyyy-dd-mm). I want to search for rows that only contains dates that are within the last 7 days, how do I do that?

1 Like
3

In search rows module of google sheets, apply following filter.

image
image836×398 18.9 KB

4

I think this would work for you:

image
image485×438 16.8 KB

1 Like
5

Hi @StarAutomations

The filter @Rebecca_Katz specified would work only if its a Date column.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like
6

Hi @Umer_Jamil
If the values are returned as text then you will have to search rows without any filter and then add a filter outside the module as follow:

image
image809×648 51.6 KB

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like