29 questions
SHIFT-JIS saves the local CSV file, so it gets garbled when you import it into Google spreadsheet.I would like to add a code to the following GAS script that you told me in the related question I aske...
https://github.com/firebase/functions-samples/tree/master/google-sheet-syncI got authentication as above site, configured in firebase.config, and deployed on firebase.The actual steps are as follows:A...
In Spreadsheets Add-on (Google Apps Script), vars=SpreadsheetApp.getActiveSheet();range=ss.getActiveRange();var values = range.getValues();Then, if the selection range is selected in Ctrl or Command o...
We are currently preparing an inspection performance chart.The light blue background part does not contain a formula, but it is a manual input part.I would like to put formulas in columns G and H so t...
I'd like to round up and devalue my attendance data.I'd like to round up every 30 minutes.The working hours are as follows, and the break time is 70 minutes, so the work hours are not separated by cle...
I would like to add a data frame to the bottom of the spreadsheet using the API of the spreadsheet. Is there any good way?What do you want to doI want to add a data frame to the bottom of the spreadsh...
in the spreadsheetIf there is a letter Apple in the cell of A, I would like to display 1 in the cell of B, 2 in the cell of B, and 3 in the cell of mandarin orange, and apply it to all the cells below...
Column C contains the cumulative sumif and row functions of column B.=ARRAYFORMULA(if(B2:B=, , sumif(row(B2:B), <=&row(B2:B), B2:B)))Currently, even if the date in column A is March, the total ...
About managing spreadsheetsThere is sheet 1 of the basic product management calendar.Release date (column A), product name (column B), and basic information (column C-G)I would like to create and mana...
| « | - 3 - |
© 2024 OneMinuteCode. All rights reserved.