So well Prepped! Logical progression from 'Immediate Need Function' to a more flexible 'General Task Function' by parameter. I can almost imagine where your next videos might progress to. Mostly I appreciate that you have, unlike so many RUclipsrs, chosen simplicity and clarity for the viewer rather than 'Showing Off' and making things too cluttered and complex just to make sure we know how much you know. Also, your inclusion of proper documentation shows your professionalism. All in under 10 minutes!
Thank you for your feedback. My goal has always been to help others. By the way, this channel will have a shift in focus. You can learn more here: ruclips.net/video/OHd_xEabivg/видео.html
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.
This is great content, thanks Saperis! I'm thinking of making it a button to convert mi to km. But i'm wondering if I can share this to my coworkers easily.
You can't attach a custom function to a button. If you want to use a button instead, you have to write a script that you attach to that button. A custom function is bound to the file you created it in. So your colleagues would have to copy your file to also use the custom function.
Nice tutorial!! I've managed to create my own function but would like to make it available to other users within the organisation without having them to copy/paste the relevant script; what's the best way to achieve this? Do I need to deploy an add-on? Do you have a video showcasing a solution to my problem?
Currently, custom functions are bound to a specific script. So you can't get around the copying of your document to share the custom formula with others. Creating an add-on for your organization might be an option. But it's going to be much more work. Here some information on that: developers.google.com/apps-script/add-ons/overview
really nice! I found the channel today and it's already helping me. I got curious, what if the 'input' is actually a result from anothers cells operations? Is it better to create a a custom function or would it be better to run a script? Could you say for us which one is more appropriate for each case?
I wrote a set of Custom Functions but for some reason they not appear in autocomplete as I write the formulas down in the Google Sheets (the functions work even though). Any idea why this happens?
@@saperis I did. I had renamed the Code.gs file to other name, say MyFunction.gs, so apparently it makes the autocomplete not work. As I watched your video again, I tried to rename back to Code.gs and the autocomplete worked for all my functions.
This doesnt work in Jan 2022! Tools doesn't have scripts menu. There is something under Extensions, however, any function I make there is not loaded in the spreadsheet when I save.
You're right: Google changed the menu in Google Sheets in December 2021. So you will find the script editor unter Extensions. But the rest works exactly the same. You can still create your own custom Google Sheets functions/formulas.
I SPENT SO MANY HOURS IN GOOGLE SHEETS DOING HORRIBLE LOOKING CELL EQUATIONS JUST BECAUSE I DIDNT THINK I COULD MAKE MY OWN CUSTOM FUNCTION HAHAHAAHA IM GOING CRAZY HAHAA!!!!
Unfortunately there's no longer a Tools → Script Editor choice. It's now Data → Named Functions. And the process has gotten more complicated (to me). I think your explanation is excellent. But Google's explanation needs some explaining.
So well Prepped! Logical progression from 'Immediate Need Function' to a more flexible 'General Task Function' by parameter. I can almost imagine where your next videos might progress to. Mostly I appreciate that you have, unlike so many RUclipsrs, chosen simplicity and clarity for the viewer rather than 'Showing Off' and making things too cluttered and complex just to make sure we know how much you know. Also, your inclusion of proper documentation shows your professionalism. All in under 10 minutes!
Thank you for your feedback. My goal has always been to help others.
By the way, this channel will have a shift in focus. You can learn more here: ruclips.net/video/OHd_xEabivg/видео.html
Brilliant! Thank you Chanel!
Glad you like it!
All Your video clip very helpful. So how I use a custom function for another spreadsheets? Thanks!
I love this channel .
I do too! 😀
Excellent..
Thanks a lot
practical, simple, usefull... :)
Glad you think so!
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.
Wrote a petrol to BWP , cost of of fuel estimator custom function. Thanks for the guide😁
Happy to help 👍
This is great content, thanks Saperis! I'm thinking of making it a button to convert mi to km. But i'm wondering if I can share this to my coworkers easily.
You can't attach a custom function to a button.
If you want to use a button instead, you have to write a script that you attach to that button.
A custom function is bound to the file you created it in. So your colleagues would have to copy your file to also use the custom function.
Nice tutorial!! I've managed to create my own function but would like to make it available to other users within the organisation without having them to copy/paste the relevant script; what's the best way to achieve this? Do I need to deploy an add-on? Do you have a video showcasing a solution to my problem?
Currently, custom functions are bound to a specific script. So you can't get around the copying of your document to share the custom formula with others.
Creating an add-on for your organization might be an option. But it's going to be much more work. Here some information on that: developers.google.com/apps-script/add-ons/overview
Awesome!
Thanks!
really nice! I found the channel today and it's already helping me. I got curious, what if the 'input' is actually a result from anothers cells operations? Is it better to create a a custom function or would it be better to run a script? Could you say for us which one is more appropriate for each case?
Good question! I've never tried this out so I can't speak from experience. In theory, an output of a formula should be equal to a number.
Mulțumim!
Thank you very much for your support!
I wrote a set of Custom Functions but for some reason they not appear in autocomplete as I write the formulas down in the Google Sheets (the functions work even though). Any idea why this happens?
Interesting. Did you make sure to add the information for the autocomplete like I do in the video?
@@saperis I did. I had renamed the Code.gs file to other name, say MyFunction.gs, so apparently it makes the autocomplete not work. As I watched your video again, I tried to rename back to Code.gs and the autocomplete worked for all my functions.
Wil leave this here just in case, you have to add JSDoc, some lines commented before the function.
This doesnt work in Jan 2022! Tools doesn't have scripts menu. There is something under Extensions, however, any function I make there is not loaded in the spreadsheet when I save.
You're right: Google changed the menu in Google Sheets in December 2021. So you will find the script editor unter Extensions.
But the rest works exactly the same. You can still create your own custom Google Sheets functions/formulas.
I SPENT SO MANY HOURS IN GOOGLE SHEETS DOING HORRIBLE LOOKING CELL EQUATIONS JUST BECAUSE I DIDNT THINK I COULD MAKE MY OWN CUSTOM FUNCTION
HAHAHAAHA
IM GOING CRAZY HAHAA!!!!
Well, good thing you found this video. From now on you'll be bossing Sheets round. 😁
How to share these custom functions to other users to use in their own spreadsheet?
Currently, the only way to share it with them is to share the entire spreadsheet.
I do not have "Script editor" in "Tools", is it outdated?
Google updated the menu of Google Sheets a couple of weeks ago. It's now:
Extensions > Apps Script
Unfortunately there's no longer a Tools → Script Editor choice. It's now Data → Named Functions. And the process has gotten more complicated (to me). I think your explanation is excellent. But Google's explanation needs some explaining.
I'm stuck too
Yes, every couple of years the user interface is updated and things aren't in the same place anymore.