Google sheets SEARCH ROWS Later than filter

Questions & Answers
1

Hello everyone, I hope that you can help me to solve my problem.
My scenario is that: Webhook receives anything, then google sheets search rows works with a filter Date column later than now date AND status equal to Word specific, than its sends data through webhook that date . The scenario worked without mistakes yet, but today when i sarted checking my scenarios this ones filter is working incorrect even all inputs are absolutely clear. Below you can see screenshot of my scenario and that filter, take a look please.

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.15
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.152676Γ—1386 307 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.41
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.412676Γ—1386 283 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.48
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.32.482676Γ—1386 277 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.04
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.041920Γ—994 94.6 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.22
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.222676Γ—1386 281 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.36
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.362798Γ—1386 464 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.47
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-02-14 Π² 20.33.472798Γ—1386 472 KB

3

Hey @Ali2

You can test this out by setting up like this below:

image
image2006Γ—833 163 KB

Instead of adding the date filter inside the Google Sheets Search rows, add it in the route filter and be sure to set the Search Row’s limit to let’s say 100 (or even more). Quick tip, when dealing with date time filter in the route filter, be sure that they have the same date format and use the Later that or Equal to DateTime operator.

I hope this helps!

2 Likes