Worked well except icon won't show up. I copied the icon url into another browser tab and it displays - I presume there is another google security setting that prevents images from displaying. Anyone know how to do this?

Thank You for the tuto 🙂 How can i insert several options into the formula? Like achived, overachieved?

is there any way to make this an automatic sync thing? in a way that people can just keep adding entries to the google sheet and it automatically appears in the google calendar? (if not completely automatic then maybe a button that they can press after adding an entry to the same sheet to add it to the calendar)

❤❤❤❤❤ AMAZING!!! ❤❤❤❤❤

Hmm… I wonder if I could convert this to google sheets using some css for ui… probably a GitHub thing.

Wow, watching this in bed. Not following along but that seems really simple and the way you explain it is so easy. Other tutorials I’ve tried don’t explain how the code works or anything so thanks!

I enterred this formula EXACTLY and it still gives me the "#ERROR!"

Very thankful ...

what if "columns" doesnt show up in my "format" drop down menu?

Excelent how to!!!

- A correction in November 2024 Replace your line 27 by the following: let icon = 'https:' + data.current.condition.icon;

Wow awesome in explaining!!!

This has been such a help! Now, I have a question. I have a sheet with multiple rows and columns (about 60 rows and 60 columns). I want to create calendar events only for select rows instead of the entire sheet. How can I do that? I'm not familiar with script/code but I was able to understand this video and did a "dummy" sheet which carried over onto my calendar. So...I have a little bit of hope.

I did EVERYTHING you said to do in this video, and I had tested it out with my personal email since this automated response thing is for my business email and it's not working for me. Can you please tell me why it’s not working? Please and thank you.

hello

Thank you!

Thankyou so much this is a life saver however it doesnt seem to send the attachment do you have any advice on this.

Is it possible to use this or IFS formula for multiple values? For example, I am working on a tip calculator sheet where if the tips are up to $375, 10% would be allocated to the kitchen, if the tips are $376-475, 15% would be allocated to the kitchen, and if the tips are $476+ the kitchen would get 20%. I feel like it should be possible but I tried nesting the formula and keep getting an error.

This would be a very helpful video if it worked, however something must have changed because when I tried following your instructions everything kept going in one column and there was no way to type in other ones and there were also no lines between columns. it was as if there were none and my writing was just squished into one side of the page.

hi in line 7 what is the relevance of the keyword "function" which (if it is a unnamed function) is being fed the array name - can you not refer to the array itself why pass it as a parameter to "function" ?

Awesome for beginners

Hey

Very useful scripts to make simplify daily activities on sheets

Hello I am trying to do what is in the video but the function doesn't show up when I type =(name of function). I tried many things. Has there ben a change or a step I'm missing from the extension store? Thanks in advance.

Hello! How do I stop sending the file again from previous people whenever I send the file to new people?

Hello! How do I stop sending the file again from previous people whenever I send the file to new people?

You're the best

That was so helpful! What if I want the other person to open the document without having to download it? Just open it up in the browser, or a new tab. Thanks so much!

Do you have copy of the script?

i found an error here "Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Sheet.hideRow." i have followed the document template as you

This is the fastest time it’s ever taken me to understand any JavaScript explanations from a video. I hope to learn more from this channel. Thank you

I have spent days and nights to do this, researching blogs, youtube, AI, etc. Finally, you made my day! Thanks a million!!

So simple... and so informative. Thanks a lot! :D. You did an amazing job with this video by introducing people completely new to coding and scripting.

Was looking for only sharing the specific person Appts with them

Very helpful thank uuuuuuuu❤

hello can you help me

Thanks! This was clear.

I wanted to create a google form that would allow for one of the questions to schedule an event. I did this and connected it to a google sheet where I had the scheduled lines separated and moved to another tab. I then wanted to have the information on the scheduled tab be the information added to my calendar. I had to change the script slightly to have it call out for the specific tab, but even though when I run the script it says it works, nothing is moved to the calendar. what do I do now?

Nice video! I was wondering how I could use a dropdown menu to subtotal all the cells in the column next to it in each category. Example: travel expense is subcategorized into lodging, entertainment, transportation etc...by using a drop down menu in the cell to the left of the expense amount. I want it to total all transportation ... into a single cell. Thank you so much in advance.

All Your video clip very helpful. So how I use a custom function for another spreadsheets? Thanks!

What caused the delay ? Is google sheets really that slow at running scripts?

thank you so much

Thank you :)

Thank you so much for such a simple consumable explanation.

merci

Is it possible to have unevenly sized/ adjustable columns in Google docs? I was only able to achieve this using the table feature.

Is there a way I can time this export to be done once a week?

I already found😀 { attachments: [pdf], bcc: '[email protected],[email protected].........' }

I like to use indexof or match to make dynamic ranges as intended within the code. it's harder but i'm trying to find a better method of streamlining and debugging it

Thank you!