Alan
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 166
Comments
Recent activity by Alan-
Hi Valentin, Here's the regex string: (http|https):\/\/.*[\S]\.[\S]* I tested this with: test test test https://www.google.com/test/test test test test and test test test http://www.google.com/test...
-
Jared, Do the summation on the column from the new sheet, not Sheet2. You need to break all direct references to the original sheet.
-
Hi Jared, COPY is not quite like just putting in the reference for the column. You'd want COPY(#Sheet!Column). This creates a copy of the data, including the current order, while not maintaining th...
-
Hi Jared, If you're doing a GROUPBY on any column (I'm betting you're GROUPBY on the customer column) you're going to need a new sheet. My first instinct is to create the new sheet with a column c...
-
Lacramioara, Unfortunately, I believe this is out of the scope of workbook architecture. Additionally, what's entered as far as formulae is concerned on a workbook doesn't directly reflect what wi...
-
Hi Matthew, CONTAINS(#Pizza; "Pepperoni") || CONTAINS(#Pizza; "Ham") Will find if your #Pizza contains Pepperoni or Ham. If you want both Pepperoni and Ham you would do: CONTAINS(#Pizza; "Pepperoni...
-
Hi Stephen, Great question. If you want to cancel a job you'll first need to know what type of job it is. If it's an Import Job, Data Link, or File Upload you'll use the Cancel Import/Link/Upload...
-
Hi Kavitha, The formula GROUPROWNUMBER() will give you a unique entry for every record, since it will be the row number for that record. You will never have any overlap because each row number is ...
-
Morgan, Is there a technical reason why you are wanting to nest everything into a single IF statement? It seems that your current approach is a much, much more difficult way to achieve what you wa...
-
Hi Fenghua, You can find all our supported SQL functionality here: Using SQL Sheets: SQL Editor Features The error message is correct. The SQL editor does n't support the CUBE, ROLLUP, or GROUPSET...