When I share data with sub-subcontractors, I use the QUERY function to return a subset based on a company name match. I never had any issues in the past, but lately QUERY has not been returning values if they are text, only if they are numbers.
Also, Sheets' "Fill Down" shortcut ⌘+D has stopped working (MacBook Air).
Did I mess something up, or did something change?
=QUERY( IMPORTRANGE(spreadsheet_url, range_string), "select Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col13, Col14, Col15 where Col5 matches 'company_name'")