Untitled
unknown
plain_text
9 months ago
945 B
2
Indexable
=QUERY(dataset,"Select * where A > 1 AND C contains '"&c_event&"' AND NOT C contains '"&c_event_e&"' AND D contains '"&c_map&"' AND E contains '"&c_team&"' AND X > date '"&TEXT(DATEVALUE( IF(ISBLANK(c_date1)=TRUE,"2020-01-01",c_date1)) ,"yyyy-mm-dd")&"' AND X < date '"&TEXT(DATEVALUE( IF(ISBLANK(c_date2)=TRUE,"2050-01-01",c_date2)) ,"yyyy-mm-dd")&"' AND (V contains '"&ci_1&"' AND V contains '"&ci_2&"' AND V contains '"&ci_3&"' AND V contains '"&ci_4&"' AND V contains '"&ci_5&"' AND W contains '"&ce_1&"' AND W contains '"&ce_2&"' AND W contains '"&ce_3&"' AND W contains '"&ce_4&"' AND W contains '"&ce_5&"' AND NOT V contains '"&cfe_1&"' AND NOT V contains '"&cfe_2&"' AND NOT V contains '"&cfe_3&"' AND NOT V contains '"&cfe_4&"' AND NOT V contains '"&cfe_5&"' AND NOT W contains '"&cee_1&"' AND NOT W contains '"&cee_2&"' AND NOT W contains '"&cee_3&"' AND NOT W contains '"&cee_4&"' AND NOT W contains '"&cee_5&"') AND NOT V = W ",0)
Editor is loading...
Leave a Comment