Set Formula with Google Apps Script

No video

Set Formula with Google Apps Script

Рет қаралды 18,264

saperis

Күн бұрын

Пікірлер: 48

@CedricBrown-wy7kq Жыл бұрын

The instruction was brief, clear and accurate. Thank You!

@saperis Жыл бұрын

Glad it was helpful! 😀

@alexshvetz58 6 күн бұрын

Very well!

@ribierahmadalkeni8453 5 ай бұрын

Thanks to all apps and services provided by Google but actually I'm still not believe that Google doesn't have the PDF editor app and This is the one of the big problems when I want to add any PDF or ask for a signature or add some information or marked inside the Google drive please add this features because it will keep anyone can use it inside the Google drive easily Thank you for reconsider

@saperis 4 ай бұрын

This is my personal KZfaq channel and I'm not Google. 😃

@aakash9217 2 жыл бұрын

This videos solve my problem thanks you so much 🤩🤩

@dawid_dahl Жыл бұрын

Thank you kindly!

@saperis Жыл бұрын

You're very welcome!

@kb7494 10 ай бұрын

I enjoyed your clear and concise video - thank you. It got me thinking about manipulating formulas using app scripts. Instead of adding a new formula to a cell, what would I do if a formula already existed in a particular cell and I wanted to update it? For example, if cell B15 contained =masterSheet1!A1 and I wanted to update it using a script to reference the same cell in another sheet, maybe =anotherSheet!A1. How do I search and replace part of the existing formula?

@saperis 10 ай бұрын

You can use the getDataSourceFormular method to get a formula from a specific cell. See here: developers.google.com/apps-script/reference/spreadsheet/range#getDataSourceFormula()

@MrChrisgapo 2 жыл бұрын

Well explained! thanks a lot!

@saperis 2 жыл бұрын

Glad it was helpful! 👍

@MonaAhmednafea 8 ай бұрын

Hi thank you for the videos! I have a questions here can I copy data from a spreadsheet to another one with the formulas the data have on the original one?

@saperis 8 ай бұрын

You probably would have to do this in two steps: 1. get the data (getDataRange.getValues()) or something similar 2. get the formulas (probably getDataSourceFormulas) developers.google.com/apps-script/reference/spreadsheet/range#getdatasourceformulas

@abdouhk1683 2 жыл бұрын

شكرا

@hhbbhvvbjhbbyjj Ай бұрын

how about if the row changes everytime how can we use it with getlast row

@Leover378 2 жыл бұрын

Buen script en pocas líneas y muy funcional 👍

@saperis 2 жыл бұрын

Gracias! 😀

@segunlawal7835 Жыл бұрын

Thumbs up for the great job you are doing Saperis. Please is it possible to create multiple menu on google sheet if you want to automate more than one task / command. Also I would like to ask how do you do screen updating a feature in VBA code on Google App Script.

@saperis Жыл бұрын

Check the guides to see how you can have multiple menu items: developers.google.com/apps-script/guides/menus I don't understand your question screen updating a feature in VBA code on Google Apps Script.

@user-df7kn1wt5o 5 ай бұрын

hello thank you for this video! Do you have any recommendations if I put a reference from other sheet in the formula? For example =IF(A2>Reference!$B$2,”Yes”,”No”). I keep getting an error results

@saperis 5 ай бұрын

I've never tried that so I don't know if it works. But for sure, you would have to use the sheet name in the formula.

@mahendrapal6010 2 жыл бұрын

Like this video and you help me then you one video make that save functions on multiple row and another sheet with script

@saperis 2 жыл бұрын

Thank you for watching the videos.

@haohuynh1808 Жыл бұрын

Hi! Do you know how to set sum of range have formula SUM() in apps script? Thank u so much.

@saperis Жыл бұрын

You should be able to set the SUM formula just like I show in the video.

@user-hg6rv8ij3f 9 ай бұрын

It would be helpful if you link the code template in the description that way you can get leads and get paid for your work

@saperis 9 ай бұрын

Thanks, but that wasn't my goal with these videos.

@RajaGiri_tvpm 2 жыл бұрын

Thank you , How To Execute Google Apps Scripts on Mobiles or Tabs (Android)

@saperis 2 жыл бұрын

You can't execute Google Apps Script on a mobile device. You could have a button in a Google Sheets that triggers a script, though. Click on that button and the script should work. See the details here: stackoverflow.com/questions/50894212/getting-google-apps-scripts-to-run-on-mobile

@RajaGiri_tvpm 2 жыл бұрын

@@saperis Thank you very much for your kind reply

@somayaahmadi4155 Жыл бұрын

how we are able to make an alert that you have done something with an audio? for example if the quantity and produced boxes be equal make an alert with an audio? can you let me know please?

@saperis Жыл бұрын

There is no way to have a notification that alerts you with sound.

@somayaahmadi4155 Жыл бұрын

thanks for replying back

@jorgepelatos2696 Жыл бұрын

hi, do you know how to calculate the power of a number? in apps script? only with code?

@saperis Жыл бұрын

No, I don't. ☹

@bloodyping9644 Жыл бұрын

to calculate the power of a number in apps script, use Math.pow(number,power), where number is your number to calculate, and power is, obviously the power to be applied to that 1st number. Or... you can also create your own power function, this is one of the many ways to make it works: function calPow(num,pow) { let result = num; if(pow >= 0) for (let i=0; ipow; i--) result = result / num; return result/num; }

@rajdeepsaini2977 Жыл бұрын

Wht u have write that is not clear

@saperis Жыл бұрын

Why is it not clear?

@crouchingchicken007 11 ай бұрын

Hi thank you for the videos. I was wondering if you could help me with an apps script formula that can minus end time of a date from start time of that day? I have data logging a Google sheet with date and time columns.

@saperis 11 ай бұрын

I don't offer any coding or consulting services. Check this directory of Apps Script freelancers: workspacedevs.com/

@crouchingchicken007 11 ай бұрын

@@saperis thank you very much. I appreciate it. Was able to adapt this to my needs with a working Google sheet and pdf exports now. Thank you.

@boredomindex3353 2 жыл бұрын

It's probably the least practical use of setFormula(). =SUM(B2:B14) will do the job much better, hassle free

@saperis 2 жыл бұрын

Thanks for sharing your thoughts.

@newyorkchickenwing Жыл бұрын

@@saperis I understand that the video's not so much about the Sheets formula (which is why you threw any old one in there) as it is about learning how to set ANY Sheets formula with Google Apps Script. This is actually exactly what I needed. Thanks!