true-basic |
TRUE |
=TRUE() |
value |
|
false-basic |
FALSE |
=FALSE() |
value |
|
sortn-top-3 |
SORTN |
=SORTN({5;2;8;1;4}, 3) |
value |
1 |
sortn-top-3-ascending |
SORTN |
=SORTN({5;2;8;1;4}, 3, 0, 1, TRUE) |
value |
1 |
encodeurl-space |
ENCODEURL |
=ENCODEURL("a b") |
value |
1 |
encodeurl-special-chars |
ENCODEURL |
=ENCODEURL("hello world/?&=") |
value |
1 |
isurl-https |
ISURL |
=ISURL("https://example.com") |
value |
1 |
isurl-not-a-url |
ISURL |
=ISURL("not a url") |
value |
1 |
hyperlink-with-label |
HYPERLINK |
=HYPERLINK("https://example.com", "click me") |
value |
|
hyperlink-url-only |
HYPERLINK |
=HYPERLINK("https://example.com") |
value |
|
importdata-csv-smoke |
IMPORTDATA |
=IMPORTDATA("https://example.com/data.csv") |
value |
1 |
importfeed-rss-smoke |
IMPORTFEED |
=IMPORTFEED("https://example.com/feed.xml") |
value |
1 |
importhtml-table-smoke |
IMPORTHTML |
=IMPORTHTML("https://example.com/page.html", "table", 1) |
value |
1 |
importxml-xpath-smoke |
IMPORTXML |
=IMPORTXML("https://example.com/data.xml", "//title") |
value |
1 |
importrange-cross-sheet-smoke |
IMPORTRANGE |
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1:B2") |
value |
1 |
arrayformula-multiply-range |
ARRAYFORMULA |
=ARRAYFORMULA({1;2;3} * 2) |
value |
3 |
arrayformula-text-concat |
ARRAYFORMULA |
=ARRAYFORMULA({"a";"b"} & "!") |
value |
3 |
query-select-all |
QUERY |
=QUERY({1,"a";2,"b";3,"c"}, "select *") |
value |
2 |
query-select-col |
QUERY |
=QUERY({1,"a";2,"b";3,"c"}, "select Col2") |
value |
2 |
query-offset-1 |
QUERY |
=QUERY({0,0;1,2;3,4}, "offset 1") |
value |
1 |
googlefinance-price-smoke |
GOOGLEFINANCE |
=GOOGLEFINANCE("GOOG", "price") |
value |
2 |
googletranslate-en-to-es |
GOOGLETRANSLATE |
=GOOGLETRANSLATE("hello", "en", "es") |
value |
2 |
detectlanguage-english |
DETECTLANGUAGE |
=DETECTLANGUAGE("hello world") |
value |
2 |
image-url-smoke |
IMAGE |
=IMAGE("https://example.com/pic.png") |
value |
1 |
sparkline-inline-chart |
SPARKLINE |
=SPARKLINE({1;2;3;4;5}) |
value |
2 |