'Google Sheets Filter Function Issue
For some reason the filter is passing through values that have final service date that is before the set day value. These should be filtered out. I've read it a few times and can't find the missing logic.
Cmpstrs!BQ:BQ - Assigned First Service Date and Cmpstrs!CA:CA - Assigned Last Service Date
=Filter({Cmpstrs!C:C,Cmpstrs!AD:AD,Cmpstrs!AQ:AQ,Cmpstrs!HA:HA}, ( ( (Cmpstrs!S:S ="Active") *
NOT WORKING-> ((Cmpstrs!BQ:BQ <= 'Set Day'!A2) + (Cmpstrs!BQ:BQ="")) * ((Cmpstrs!CA:CA >= 'Set Day'!A2) + (Cmpstrs!CA:CA="")) <-NOT WORKING * regexmatch(Cmpstrs!X:X,'Set Day'!B2) * ((Cmpstrs!U:U='Set Day'!E2)+(regexmatch(Cmpstrs!U:U,'Set Day'!C2))+(Cmpstrs!U:U='Set Day'!D2)+(Cmpstrs!U:U="All")) ) +(Cmpstrs!S:S ="Status") ))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|