Filter data with a condition greater than, less than, a numeric range or dates

Support
1

I wanted to know if you can have the possibility of filtering or searching the data by operators such as greater or less than … or a range of numbers or dates.

This function is very useful and important to search for example range of dates in invoices or amounts, for my work it is essential.

Thank you very much for the reply.

1 Like
2

Hi,

You can achieve this by filtering through the left sidebar.

3

I do not see a method to Filter Less Than or Greater Than in the Help Link provided by @Angie

4

Hi,

Only numeric fields and date fields support this type of search. For the rest of field types, the values are stored as free text. Hence, they don’t work with numeric logic like less than or greater than.

5

image

I am trying to create a shared view with a filter applied to a date field.

Ideally, the criteria would be:
From: blank
To: TODAY()+7

Is it possible to do?

I believe a workaround would be to have a field in the sheet with a formula IF(TODAY()+7, “Yes”, “No”). I could then easily filter by “Yes”, but that would require a calculation to be performed daily, which is not desired for this sheet.

Any ideas?

6

Hi,

You can click on the gear icon and apply “Next 7 Days” to achieve this:

image
image384×814 47.7 KB