Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 297772

For questions about using Google Apps Script to extend Google applications

0 votes

How to write in a proper way to skip copy the empty rows from this form? Thanks!

Do you know this? This means that after you have formed the next var values = [], you can concatenate 5, 6, 7, 8 and 9 elements and check if the result is an empty string. Not? Then do the recording. …
JohnSUN's user avatar
  • 896
2 votes

Creating a reset button

Welcome! There are several easy ways to get this job done. One of them is macro (see Automate tasks in Google Sheets). Step by step: Start macro recording, make sure "Use absolute references" is sele …
JohnSUN's user avatar
  • 896
1 vote

How to divide the values of a table in google slides by a number using App Script?

Welcome! I dare to suggest that you don't really need to really divide numbers by a million - you need to display the contents of the cells as if they were reduced by a million times. Try using the fo …
JohnSUN's user avatar
  • 896
0 votes

Split, Flatten, and Repeat Cells in Certain Columns Within an Array Formula for Google Sheets

Welcome! Let's try a not-so-long script instead of a long formula: function SplitAndCombine(aSourceData,delimiter =",") { var temp = []; var ind = 0; for (let i = 0; i < aSourceData.length; i++) …
JohnSUN's user avatar
  • 896