=query(uploadSubscriptions!A:BD,“Select * where AE =‘Active’ or (AE<>‘Active’ and (AA= ‘No Lead’ or AA = ‘Won’) AND (AC > date ‘” & text(today() - 730, “yyyy-MM-dd”) & “’)) ”,1)
This is how I’d write this out in Google Sheets. I think the syntax is a bit different in Sheetgo so I’d like some help translating.
If it helps I’m basically trying to do the following
Include all row…
where column AE = active
or
where column AE <> active AND (column AA equals “Won” OR “No Lead”) AND the date in column AC is greater than 2 years ago from today
