A easy way (if you don’t have that many columns) would be to use a literal array and filter out the empty cells with query. Something like this =join(“, “, query({C3:C; D3:D; E3:E; F3:F}, “where Col1 <>””)) Also see cell A1 in the spreadsheet you shared. UPDATED: An alternative (and shorter) way would be to … Read more
Copied from Web Applications: =QUERY(Responses!B1:I, “Select B where G contains ‘”&$B1&”‘”)
There is no need to use formulas for that, you can define your own custom formats. Just go to Format -> Number -> More formats -> More date and time formats. It will open a window with several date and time formats to choose from. You can define your own as well, using the upper … Read more
If you copy the formula you quoted into another row, or fill it down using Ctrl+D, it will automatically change the reference to the row you are copying/filling to. This is called a “relative reference”. If you use the formula =PRODUCT($A$1:$B$1), this is called an “absolute reference”, which will not change if copied elsewhere. You … Read more
In the cell you want your result to appear, use the following formula: =COUNTIF(A1:A200,”<>”) That will count all cells which have a value and ignore all empty cells in the range of A1 to A200.
Here is what I found for Google Sheets: To get the current sheet name in Google sheets, the following simple script can help you without entering the name manually, please do as this: Click Tools > Script editor In the opened project window, copy and paste the below script code into the blank Code window, … Read more
The current cell is addressed by the first cell of a range in the conditional formatting. In your example, the range is A4:M10 and therefore you can use A4 as “current cell”. Check for empty content: =A4=”” Relative vs absolute references in conditional formatting work just like copying a formula. Check that the cell in … Read more
If you want to copy conditional formatting to another document you can use the “Copy to…” feature for the worksheet (click the tab with the name of the worksheet at the bottom) and copy the worksheet to the other document. Then you can just copy what you want from that worksheet and right-click select “Paste … Read more
It will likely have been solved by now, but I ran accross this and figured to give my input =COUNTIF(a2:a51;”*iPad*”) The important thing is that separating parameters in google docs is using a ; and not a ,
To Add to AlexG’s answer, a better and enhanced version of multi-select is found in this following link (which I tried and worked as expected): https://gist.github.com/coinsandsteeldev/4c67dfa5411e8add913273fc5a30f5e7 For general guidance on setting up a script in Google Sheets, see this quickstart guide. To use this script: In your Google Sheet, set up data validation for a … Read more