วีดีโอ

So glad this was helpful! You can right-click on any single column or row number (e.g. the part where it says A,B,C etc. or 1,2,3, etc) and delete that single row or you can select multiple rows or columns and do the same thing. So for example if you want to delete all the rows after row 30, you can click on "31", scroll down, hold down Shift and then click on "1000", right-click and select "Delete 969 rows"

Is it a Google Sheet that you created awhile ago? It's possible if it's an older sheet that for some reason it's blocked for that reason. Otherwise if it's a new or newer sheet, it may just be a glitch. You can check this playlist for access to download different Google Tables templates: th-cam.com/video/fxuW2QO38qA/w-d-xo.html

@@SheetsNinja It's a new sheet. Must be a glitch of some kind. Not the end of the world, I can just edit other templates.

So with Google Apps Script, there isn't a way to upload files from C drive natively without user interaction. You would have to have some kind of service on your desktop that the script could access. If you're wanting to upload CSVs from your computer on a regular basis or with automation, what you'll probably want to do is get a python or other local script. Another option is download "Google Drive for Desktop" and then when you're on your computer, you can drop files right into a Google Drive folder shortcut on your desktop: www.google.com/drive/download/

This means somewhere you have a formula referring to another formula referring back to it. Whatever formula you're adding when you get this error, you'll want to check the cells referenced in the formula to see what cells they reference. Usually what it is in this kind of case is you need somewhere to actually set the initial inventory and then you can add/subtract from there.

@@SheetsNinja Okay I fixed that but now when I made the report, it's 0's all across. for some reason it's not pulling the data from the log

Oh, thank you! I do not know why it doesn't work in mobile! I just tried it myself and sure enough, it does not work on the mobile app at the moment! I'm assuming the current UI in the mobile app doesn't support the multi-select and that's what they will have to update. So maybe in the next Sheets app update?

I got it sheet.getRange('A1').setValue(timestamp);

You need to make sure the tab name matches between the Google Sheet and the script (sometimes a blank space at the beginning of end of a tab name can throw you off in the script)

Glad this was helpful!

You bet!

Glad it was helpful!

You're very welcome!

Awesome, so glad this was helpful!

lifesaver, thank you so much!. Much simpler than other video, great video. Wish you had more subs.

Awesome, so glad this was helpful for you!

Awesome, so glad this was helpful for you!

Awesome, so glad this was helpful for you!

@@SheetsNinja YW! ⭐️

Glad this was helpful for you!

Glad this video was helpful, and thanks for the idea, I'll keep it in mind.

Glad it was helpful!

Glad it was helpful!

Are you talking about smart chips? If so, Google has not updated apps script to be able to pull data from smart chips. Otherwise if you're talking about links that you added, you can switch out .getValues() for .getRichTextValues(), so something like this: **replace the .getValues() and .appendRow() lines with these: let data = sheet.getRange(row, 1, 1, sheet.getLastColumn()).getRichTextValues(); targetSheet.getRange(targetSheet.getLastRow() + 1, 1, 1, data[0].length).setRichTextValues(data);

Yes, so you could set up another helper tab and do the same thing again. I walk through the logic (just sub in the new formula I use in this new video) in this older video on regular dependent dropdowns: th-cam.com/video/xzzDNDNkO6Y/w-d-xo.html

@@SheetsNinja I find that I'm struggling to get it to work with the columns in my second helper sheet

If you have not authorized the script, that would be the #1 reason why this wouldn't work. Other than that, what you would want to check is when you pull up the Script Editor, on the left-hand side, check the icon that looks like three lines and an arrow, labeled "Executions", and see if there are any executions happening for the script, and if they completed successfully or if there are errors.

@@SheetsNinja Got it thanks! I will look into those.

Hey there, from what it sounds like, you may not have restrictive enough if statements, or you may have two onEdit triggers. This can happen if you either add a trigger multiple times or your main script is onEdit(e) and then you also add a trigger for that function. If you're in the script editor, double-check your function name, and then click on the clock icon on the left-hand side, and see if there are any triggers listed. If there is any triggers listed and your function name in the script is onEdit, then you should remove any triggers tied to it. Otherwise, if your function name is something like checkMySheet(), then just ensure there is only one listed. If this isn't your issue, then my guess would be that your if conditions to determine where the row goes both allow the row to go through, so you need to make them restrictive enough that only one will be true... e.g.: // name sheet if (col == 12 && val != ''){ // rest of name sheet part of the function } // weekday sheet if (col == 16 && val != '') { // rest of the weekday target part of the function }

So if you have a lot of options, you could get that error because Google will automatically add more rows, but not always more columns. So in this case, you just need to add more columns to the right of your formulas in column A. If you select multiple columns (click on "B" for example, hold down shift and then click on "Z", then right-click and select "Insert __ Columns" (left or right), and do that until you have approx 101 more columns, then it should populate.

@@SheetsNinja YES that was exactly it. thank you!! not to be dramatic but this changed my life

Thank you! Cheers!

Add-ons can make your life easier if the standard configuration provides what you need. Usually it's the customization to fit your exact needs is where those fall short, or when the cost exceeds the value it provides. If it works for you, then awesome! Otherwise you may look for a compromise of using an add-on and customizing it in the Google Sheet, or building something from scratch like the solution I demo-ed.

Glad this was helpful!

Glad it was helpful!

I just added a new video on how to add dependent dropdowns for multi-select dropdown fields: th-cam.com/video/AFPasThu9sE/w-d-xo.html

So glad this was helpful!

All you have to do is have two columns (right click on any column header and click "insert columns" if needed) and then click on the dropdown arrow and change the input type to "Date." and you will be good to go!

Thank you! I keep trying to improve with each video, glad to know it's appreciated!

Hey, you can delete rows in the range and the conditional formatting will still work.

So the conditional notifications that Google implemented for the business accounts can make simple notifications easier, but it doesn't give you any customization on what gets included in the notification or how it's formatted. You can see a quick walkthrough of how to set up Google's notifications here: support.google.com/docs/thread/278360807/google-sheets-new-feature-conditional-notifications?hl=en

Awesome, so glad this was helpful for you!

Awesome, so glad this was helpful!

All you have to do is remove this line of code: sheet.getRange(row,col).uncheck();

@@SheetsNinja Thank you, and is there any way to change where the email alert should come from? meaning from which email address?

@@davidfriedman8917 the email notification comes from the Google Account you use to setup the trigger.

Awesome, so glad this was helpful!

The categories available in the pivot table are the column names. If you watch the video, you will see the original data has date, region, sales rep, etc. You'll need to look at your data and see what column names correspond to the categories you're looking for. So maybe instead of "Date", the column name you need is "Sold Date" or "Transaction Date" and so forth.