New answers tagged

-1


0

try this: =REGEXEXTRACT(B1,"\d+\.?\d+$")*1+REGEXEXTRACT(C1,"\d+\.?\d+$")*1 REGEXEXTRACT part of formula "\d+.?\d+$" does this: \d - match and retun digit from 0 to 9 \d+ - gives one or more digits . - any symbol \. - dot ? - makes previous symbol optional (we use it here to match integers) $ - matches end of string


0

Here is how this can be done. The function sync should be set to trigger on edit (via Resources > Current project's triggers). The arrays in the first two lines should be filled with sheet names and cell names that you want to sync. If the edited cell matches one of those, then the rest will be updated to have the same value. function sync(e) { var ...


0

This function can be used in each of the destination sheets to copy back to the main sheet. function onEdit(event){ var range = event.range; if(range.getSheet().getName() == "Sheet1" && range.getColumn() > 1 && range.getRow() > 1 ){//example conditionals to limit the action to exclude headers or other static data could be changed ...


0

Google Sheets doesn't have a range syntax for whole sheet range. The following formula will return the range address of the whole sheet named Sheet1 ="Sheet1!"&ADDRESS(1,1,,TRUE)&":"&ADDRESS(ROWS(Sheet1!A:A),COLUMNS(Sheet1!1:1),,TRUE) In order to use it as reference, put it inside of INDIRECT. The following formula will return an array of all ...


1

Short answer At this time Google Forms can not validate input data against an external list of valid values. You could ask Google to include this feature through Google Feedback. Explanation Google Forms include input validation for email addresses but this only check if the input was wrote correctly as email addresses, it doesn't check against a list of ...


0

You should use the getEvents(startTime, endTime) method. That method returns an array of events. Unfortunately, the documentation kind of hints at what data type is returned, but doesn't "spell out" that the return type is an array. An array has a length property, which you can easily use: theArray.length You can check the length with a conditional ...


0

There appears to be a menu item that can help with this, at: Data → Split text to columns... Single click on a cell and paste your data. It will appear over multiple rows but only one column. Leaving the newly populated cells highlighted, go to the menu Data → Split text to columns... If the app managed to auto-detect your separators, then ...


1

At this time this it's there are only two kinds of range properties to handle its content: values and formulas. Unfortunately changing the cell content using them removes the format applied to parts of the content. In case like this, users could take a look to the Google Apps Script Issue Tracker to search for a feature request and in case that there isn't ...


-1

Why don't you simply copy this list, with each choice on a separate line (in a text file) or in cells along a column and then paste (ctrl+v) in option 1 textbox? Doing this will generate the pasted items as separate choices, simple!


0

This is how such a script can work. The variable startRow is fixed at 12 here - an alternative option is to take it from the current selection, which would be startRow = sheet.getActiveRange().getRow(); The script then searches column A for "end of list" text, and then deletes the required number rows. function deleteRows() { var startRow = 12; var ...


2

The message is pretty clear: you are invoking the service too often. This is discussed in Google URL Shortener 403 Rate Limit Exceeded which indicates that the acceptable rate is somewhere between 1 and 10 requests per second. Use the method Utilities.sleep to slow down the requests. For example, Utilities.sleep(1000) within the loop will ensure a 1-second ...


1

onEdit can be written to take an event parameter that among other things contains the range that was edited. Changing the function declaration to take a parameter 'event' and changing r to be event.range instead of the activecell gets the exact behavior I believe you want. function onEdit(event) { var s = SpreadsheetApp.getActiveSheet(); if( ...


1

The Google Apps Script Editor doesn't include print command and doesn't have a command to wrap lines either, so we could say that it's not print friendly. One solution is to to copy the code and paste it to another app that include better print options. Another alternative is to use a desktop editor. See External Editor Support for Google Apps Script - ...



Top 50 recent answers are included