CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
user14397867
user14397867

Reputation: 37

Filter Array If Date >= Today()

I am trying to use the filter function to show only data in combination with the importrange function that meets certain conditions. I currently have the following formula:

=filter(ImportRange("XXXXXXX","Sheet1!A2:A"),ISBLANK(ImportRange("XXXXXXX","Sheet1!C2:C")),CONDITION2?)

So I currently have 1 condition that works, import the range if the value in range(C2:C) is blank; however, I am having trouble figuring out adding the second condition where it will import the range if there is a date and if that date is >= Today() in range(C2:C).

Upvotes: 0

Views: 585

Answers (1)

Marios
Marios

Reputation: 27348

It is preferable to you use Query instead:

=QUERY(ImportRange("XXXXXXX","Sheet1!A2:C"),"Select Col1 where Col1 is not NULL and Col3 is NULL or Col3 > now()")

In order for this solution to work, column C must contain the dates in the correct format or null values (empty cells).

example

Upvotes: 2

Related Questions