Var colFDataLen = colFData.filter(String). Var colBDataLen = colBData.filter(String).length This is basically the 'Sheet ID' and as you switch sheets/tabs in Google Sheets, you'll notice this value changes and you can basicaly just copy that ID and append it to the URL if you want that specific sheet exported. Var valueToCheck = sheet.getRange('F99').getValue() URL to download just a specific sheet/tab to Excel: Notice that the difference is we included &gid1330027783 to the URL. Var sheet = SpreadsheetApp.getActive().getSheetByName("Order Tracker") I know that MailApp would be the way to go for the email part, but I’m unsure how to handle the if statement portion. However, I’d like to ensure that all orders are being filled by having an email get sent out at the end of the day if a cell does not have an order number.įor example, if a cell in Column B has a value and a cell in Column F does not, send an email notifying that row # has not been filled. I have a simple tracker running in Google sheets - information gets imported into the sheet daily from a CSV, the info is used to fill an order, and an order number is filled in to a cell next to that row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |