วีดีโอ

Most likely you have a minor typo in your Google Sheet. If you carefully compare the formula there will be a slight difference between the two.

#gid=

You're welcome!

Yes, you can. The reason I added the action column was to easily differentiate between new and existing events. If all you are doing is creating events, you can simplify the script and just add all to Google Calendar.

I appreciate that! Thanks so much!

If you make a copy of the example, you can take a look at the code there and compare to your own code.

It can, you would just have to add a way to determine which calendar you want to add the event to and then have those calendar event ids in the script as well and then toggle between calendars that way.

So if need to move it to another spreadsheet altogether, first of all, you need to remove the "@OnlyCurrentDoc" line in the script if you have it. Next, you need to update the targetSheet variable reference. For example, something like this: let targetSS = SpreadsheetApp.openById("TARGET_SPREADSHEET_ID") // this is the alphanumeric id of the Google Sheet (the long string of characters after "d/" and before "/edit") Then we can update "targetSheet" to refer to that spreadsheet: let targetSheet = targetSS.getSheetByName("target_sheet_name"); After that, you can use all the same coding.

If you do not have any rows that match all the criteria, you will get "N/A" as your result. Double-check your other dropdown settings to make sure you have data matching all the criteria you have selected. Otherwise you may have something like "=" instead of ">=" or "<=" which would mean it would only match the single date instead of the date range.

@SheetsNinja tks for the quick response.. Will check again tks,

Hi Ninja.. fixed.. tks for your help. It's a great Dashboard.

Yeah that is super annoying they restricted the multi select to the chip. MAYBE they will update that at some point, but they've been working on and adding the smart chips functionality as part of the bigger push so it's likely not going to happen. In which case if they change how chips work and how easy they are to delete, that at least would be helpful.

In my understanding, colom B is date

You're looking at the columns in the search tab, but it's actually searching the "DATA" column, and the product is in column B there.

@@SheetsNinja "Yes, I just realized that it's a different sheet, thanks."

Awesome, so glad it was helpful!

You are welcome! Glad it was helpful!

Yes, you would just need to include something like this in the "if" statement: if (tabs[i].getSheetName() != 'Table of Contents' && tabs[i].getSheetName().indexOf("keyword") != -1) {

@SheetsNinja oh wow, thanks for the fast response! I'll see if I can make it work in my file, if I can, that'll save me so much time..

Awesome! So glad you enjoyed this video!

There are some "benefits" to chips (for example, with the new multi-select functionality, you HAVE to use chips), and I do appreciate the option to use the chip aesthetic, but I would have greater piece of mind if they made them harder to accidentally delete.

Awesome! Glad this was useful!

Awesome to hear! Music really makes everything better, right? Thanks for checking it out!

So if the data is going to be sorted, then you will want to use a different method. 1) is using a single cell hack, with a walkthrough here: th-cam.com/video/rFiFxoO407M/w-d-xo.html Or 2) you can use a scripted method, which is resilient even when the data is sorted: th-cam.com/video/5Yysv-QouTQ/w-d-xo.html

Google added a new permissions flow for any external connections (any images pulled in or external data connections). This is designed to keep people safe, primarily from making a copy of an existing Google Sheet that has nefarious images or data connections. If you are the one that added the photo link, then you can just click "Allow" up top and you'll be fine!

@ right, how do i go about it then so do the same =image(url)=1? the url im using its actually from instagram...

@@itstammyhere Yes, you use the same formula =image("url",1) When you hit enter, you should get prompted to allow access, once you click "Allow Access", the image should display. Occasionally you may have errors trying to display image links in Google Sheets. 1) Some websites block direct linking to their images (or restricted to logged in users), and 2) sometimes what looks like the link to the actual image is actually a link to the site or webpage and won't display then either. A quick test is to paste the link in a new browser window and see what it displayed (if anything).

You would have to export the chart one at a time. It may or may not work in your final application depending upon whether you can stack the charts there like I did in this walkthrough.

resolved! silly caps . WRote ID instead of Id

The link provided in the description allows you to make a copy of the Google Sheet to your Google Drive. If you are on Google Workspace, you may have an error if custom scripts are blocked. If you sign into your personal Google Account, you can get around the restriction that way.

So glad this was helpful!

Yes, if you select command palette and search for "high-contrast" you can toggle a different style, but for me, it doesn't make it dark mode and doesn't have any additional customization that the add-on includes, which is a variety of different schemes (which highlights the code differently as well), and the ability to hide the file structure to make for a streamlining coding experience. So if all you want is high-contrast, then you can forgo the extension, but if you do much coding, I think the extension is still worth checking out.

Awesome! So glad this was helpful!

So I got into several methods of doing just that in this video. I go into an advanced case at the end to filter multi-select dropdowns in the data as well as from the reference: th-cam.com/video/uSbsnkfqX1Y/w-d-xo.html

So having too much data on the source or destination sheet can be an issue. Google Sheets has a technical limit of around 10 million cells, the functional limit really depends on how many formulas you have on your sheet. Also, importrange also has a limit of how much data you can pull between spreadsheets. I haven't nailed this one down exactly, but somewhere in the range of 500,000 characters (so around 500,000 cells if each cell only contained one character). If you have that much data, you may need to segment unrelated data (or any data that doesn't need to be stored together) into different spreadsheets. So for example, what I may do is yearly archive spreadsheets, condense the data on each one into useable extracts and then reference those in my main spreadsheet.