If column C has the word "Matured", and D has a valid date, then formula in column E should automatically generate a serial no., one higher than the previously
I'm new to using apps script and I'm just trying this out. I want to convert zeros to blanks. This is the code I've managed to create, but it doesn't work and I
I am a beginner programmer. I am trying to make a website that does the following: Displays a map using Google Maps API Displays a form with checkboxes that lin
I've scoured the forums but can't find an answer. And this is the 2nd time I've had to write this! I have a google workbook where "Sheet1" gets its data from a
When clicking "button1" I would like the code to check the First Cell (Column A) of Rows 38-58 and hide the Row if the corresponding cell is empty and show if i
I need to extract each word (phrase) within a cell in google sheets and put each one under the other in a column (row for each one). I have a regex code that w
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Google Sheets has the following IF Function: IF(logical_expression, value_if_true, value_if_false) Is it possible to have multiple 'values_if_true' where the fo
How to RegexReplace but only for number. I tried this formula, but it didn't go as I expected: =REGEXREPLACE(A2, ":<BR CLASS="""">[0-9]", ": [0-9]") Th
I have cells containing data in google spreadsheet as quantity of some entity and I wish to extract only that string which is after the quantity value (number).
I cannot work this out: In Google sheet, I'm trying to unpivot a wide and long table by using this formula: =ARRAYFORMULA((SPLIT(FLATTEN(sheet1!$J$3:$J&"//"
I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate gr
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce. How can i find the length of the output or
Simple contact web form. I cannot figure out why it does not work as intended. On open sets up a menu, allows me to select a modal, non-modal or sidebar for for
Say that I have a dropdown list based on a column that has "cat, dog and rat" on it, and some lines select the option rat on the dropdown. After that I remove "
I am trying to do something and I am almost there but I have been scratching my head on a 'length' issue for quite some time now. What I want to do : Get data f
I am very new to Google Script. I have some pdf files in a folder on Google Drive and I am trying to convert pdf to google doc and extract specific text. PDF ha
I want to automate a report where we want to add 200 rows of data into a spreadsheet, the data in these 200 rows comes from Google Analytics with each row havin
I'm working in a google spreadsheet with multiple sheets. This is a situation where I can mess around in a sheet (I call it Sandbox) that I make but can't do an