I am trying to automatically hide a sheet called “Add expense” when I am not active on it. For example. I have the sheet “BD Expenses”, the sheet “BD Tokens”, the sheet “BD Income”, the sheet “Add expense”, the sheet “Add income”. What I want is that when I am active in any of the sheets that is not called
Tag: google-sheets
How to Highlight row based on particular value in the table?
I’m working on a YouTube tutorial that works on Google App Script and Google Sheets I want to highlight the row if it contains the value “ABSENT”, I tried many ways to but ended in failures, Need some assistance to modify this code to do the job NOTE: Updated the code for better understanding. CODE.JS INDEX.HMLT Answer
getLastRow() stops at row 68
I have this function that is supposed to pull form data from one sheet then add it to another but it stops at row 68. When I change os.getLastRow() to 192 in both locations where it appears in the function, all the information is copied over correctly. I would like to not have to specify the number of rows every
Getting specific charts from array in google script
I’m having trouble getting specific charts from a spreadsheet using an array. The code below is an extract of a function that sends an email which includes charts: The only values of chartBlobs in the final line of this extract that sends an image of a chart in the email are chartBlobs[i] and chartBlobs[0] even though there are 4 charts
Google Apps Script – If Last Column in table, then paste data with new row
My information is set in columns (A to E), info paste in 2 rows (A2:A3, B2:B3…). What I want to happen is when info set in last column E (E2:E3, E5:E6 and more), new info paste with a new row in column A (A5:A6, B5:B6). My info is in the spreadsheet: This code paste info doesn’t work correctly: Answer Here
Google Sheets, Import data from multiple sources into one, and create new tables
The source data that i want to import, its on a different multiple worksheets This image contains all the data that i want to send to the main table, Two of the tables are filled in manually, i want to do the third one using a script entirely I’ve already figured out how to write data from one sheet to
How to send/archive a row of data from one sheet to another through trigger?
I would like for a way to send a row of data from a sheet (Sheet) to another (Sheet Archive). If “Archive” is written in the 2nd column of a row, it sends the data to the archive sheet. I want the data to stack one row after another. Say I archive row #20 in Sheet #1, I want it
Google script – use every time the newest sheet
I want to create a script which should use everytime the newest sheet. The sheet gets updates from another group and I want to create an email alert, if I have something to do. Everytime this spreadsheet get an update from another team, they create a new sheet with name of the date (TT.MM) and make the old one invisble.
JS sort array by two columns of Dates
I am trying to sort an multidimensional array by dates in two columns. Each element of the array looks like that [Thu Feb 25 10:00:00 GMT-05:00 2021, Tue Mar 09 10:00:00 GMT-05:00 2021, 1326M98301, 1326M98301, product 3, 1.0, 2.188120526039E12] I want to sort it first by the second column and then by the first. Lets say that first column is
How to update data validation for a certain range within a specific column with a master list with Google Apps Script?
I have two sheets, both have a column that use data validation in Column G/#7, starting from row #8 and all the way down. I have to edit the data validation every once in a while and match the lists for both sheets. This can be annoying since it starts from row 8 down to row 1000+ and needs to