Questions tagged [syntax]

Apply to questions specifically about the structure required for commands to be recognisable for triggering appropriate actions. These questions will normally require a tag for an app or programming language in addition.

Filter by
Sorted by
Tagged with
1
vote
1answer
2k views

QUERY error NO_COLUMN:col1 [duplicate]

=query(importrange("12HAbnTv4g_6m1UeCOs9ZO0gAYvy8tlaXr-cc2ecPEic","Master!A:ba"), "select col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col53 where col53<> ...
0
votes
1answer
206 views

Is there a way (i.e. URL parameter) to force duckduckgo to only show results with ALL SEARCH TERMS

Maybe it is a recent change, but it seems that duckduck.go has started to return search results, containing pages, that do not indeed contain ALL THE SEARCH TERMS, of the query. This question looks ...
1
vote
3answers
108 views

Google Sheets issue with literal constants in functions [duplicate]

When attempting to use any literal strings in formulas I get a Formula parse error and #ERROR! in the column with the formula. For example: =IF(D43=“x”,MULTIPLY(E42,2)). I’ve been told that ...
1
vote
1answer
53 views

How to stack ranges horizontally?

If {range1; range2; range3} (I believe this is called embedded arrays) outputs the combined data in a column - top to down, what puts them side by side next to each other? The 3 ranges may or may ...
-1
votes
1answer
409 views

Google Sheets IMPORTHTML parse error

I want to use the IMPORTHTML function of Google Spreadsheets. There is this example by Google itself: =IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) Unfortunately (like ...
0
votes
1answer
36 views

Enter Tab Name In Cell To Calculate Sum of Column or Range

I have seen one other similar question on this topic posted a few years ago, but I have been unable to have any success with the suggestions given there. I have sales sheets (a new one added each day)...
0
votes
1answer
41 views

spreadsheet conditional: if in top x then

spreadsheet data: Total Average Highest Top Sales $23,550.00 $7,850.00 $8,100.00 not $42,700.00 $14,233.33 $14,400.00 not $30,500.00 $10,166.67 $10,300.00 not $37,840.00 $12,613....
1
vote
2answers
1k views

QUERY error for BY column

I'm using the following query to pull data from one sheet into another. =query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, BB, BZ, CA, BA where J = 'Industry Certification'",false) The above query ...
-1
votes
1answer
122 views

Word merge syntax

So I have been having a blast developing user friendly forms to fill out rather arduous documents lately, but as I have been experimenting with repeating sections, getting them to import properly has ...
2
votes
1answer
1k views

What is the exact syntax for linking to a Facebook ID?

Until recently, it was possible to link to pretty much anything which has a Facebook ID using syntax like this in status updates, comments, chat messages and probably elsewhere: @[398643386827709:...
4
votes
2answers
5k views

URL syntax and display options?

I recently came across a Google Sheets that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key: &single=true&gid=0&range=B5%3AB5&output=html I ...