Unfortunately, I cannot understand about your actual situation.In this script, the values of cells "A10:A15" in the sheet of sheetName are used as textsForStrikethrough.Spreadsheet.getActiveRangeList().setFontLine(null) Ĭonst sheetName = "Sheet1" // Please set the sheet name.Ĭonst sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName) Ĭonst textsForStrikethrough = sheet.getRange("A15:A20").getValues().flat() // AddedĬonst modify = range.getValues().reduce((ar, e, r) => ) => richTextValues = py().setTextStyle(start, end, textStyle).build()) Var spreadsheet = SpreadsheetApp.getActive() The individual in charge of updating the sheet daily will make all the daily changes, then once done click to button to clear any strikethrough and initiate based on new names input, if there are any. Here is the code attempted where I am getting illegal argument on Line 27 currently. I have been unable to find a decent writeup on something like this so am requesting assistance if possible. I'm reasonably technical, but am not familiar with script writing. I have seen pieces here and there, but nothing that is complete enough for me to even determine a starting point. The problem I am running into is I cannot successfully find any code for even a starting point. There could be multiple individuals off, so it would need to include a series of cells to reference. I would like a script that can be run that would strikethrough the names of the individuals identified as off for the day. There is also another field that indicates employees off of the day. I have a workflow list that shows names of employees assigned to a task. I'm looking to get some help with Google Docs and Scripts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |