google-sheetsarray-formulasgoogle-sheets-querygoogle-query-languageimportrange
Importrange doesn't work when last digit is 0 in a number
When I import 35% discount from my google sheet, it works; but when I want to import 40% discount, it doesn't work. Why?
Solution
=ARRAYFORMULA(QUERY(TO_TEXT(IMPORTRANGE(
"10UIQseUBLhJ3BRI-pOqROvYtSbWNCRrj054LGH0peDE", "All Books!B2:L")),
"where Col11 contains '40' limit 10", 1))
- SUMIF is giving me wacky numbers when inside array. Other answered questions were for more complicated issues. How can I fix this?
- Running a similar App Scripts code on Multiple Sheets
- Shortens the data back to 5 characters if you put more that 5 in
- How to use query and flatten formula in google sheets with null & desc
- How to clear a range in google sheet via gspread
- Conditional formatting if a cell is a duplicate value
- Google Script to return calendar guest names (only) into one cell separated by comma
- onEdit to run only on one cell in one sheet
- How to extract url from Google Sheet Cell with anchor text hyperlink
- Function onEdit(e) works only for single cell edit
- Cancel Script is a cell is RED
- Can we hide column in sheet using google apps script?
- JavaScript function in Google spreadsheets to send QR codes to emails
- Google Sheet Concatenate + Filter
- Google Sheets QUERY is returning with a no column found errors
- Get eventID for Google Calendar Event
- How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?
- COUNTIF Statements: Range Across All Sheets + Cell Reference as Criterion
- Writing a googlefinance wrapper
- Getting a macro to run using checkbox in google sheets
- Auto expanding formula in google sheets to the length of a dynamic range
- Issue in Auto close Modal Dialog - Google App-Script
- CSV extracted automatically into a sheet. Need help for filtering
- How can I sum top 5 values from column in Google Sheets
- Remove duplicates based on one column and keep latest entry in Google sheets (while ignoring blank entries in that column)
- Find the list of different values in 2 tables by id key
- VAT Checker Apps Script
- Script to lock a different tab sheet everyday
- Trigger python code from Google spreadsheets?
- Function to convert Google Sheet Table into one row