Google Sheets: <=0 vs < =' ' in a query

I have Google sheets that track payroll for my salespeople. I had six copies, 1 for each employee. The tab that pulls in each employee's sales uses this formula =QUERY(Data!A:H,"Select A, C, D, E, F where H<=0 AND (D = 'OPS H&S Follow Up' OR D = 'Signed & Sold')",1) which was written by the people at Excel Chat. I recently hired 2 new team members so I copied an existing payroll Google sheet. Now that formula doesn't work. I reached out to Excel Chat and they re-wrote the formula to be =QUERY(Data!A:H,"Select A, C, D, E, F where H<='' AND (D = 'OPS H&S Follow Up' OR D = 'Signed & Sold')",1) which is the same but uses H is less than or = ' ' instead of less than or = 0. That formula works for the 2 new employees but NOT for the 6 existing employees. I've tried clearing the formatting on the Data! tab of both documents in case it was a formatting issue but that doesn't help. Can anyone help me figure out why I have 8 copies of the same document and 6 need one formula while 2 need a different formula?

Thanks!

Can you post your shared Google Sheets URL to see what you have?

Unfortunately, I can't because I'm new and can't post links yet. I've emailed the mods to ask that the restriction be lifted.

please try this combination formula:

Please Login or Register  to view this content.