Set Formula with Google Apps Script

In this video you will learn how to set a formula with Google Apps Script. We will be setting the SUM formula in a Google Sheets cell.

0:00 Intro
0:31 Write the script
4:25 Run the script

#SetFormulaWithGoogleAppsScript #GoogleAppsScript #GoogleSheets

saperis - Be more productive by mastering Google Workspace!

[CedricBrown-wykq]

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

[ribierahmadalkeni]

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

[MonaAhmednafea]

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?

[aakash]

This videos solve my problem thanks you so much 🤩🤩

[hhbbhvvbjhbbyjj]

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

[DhanaRama-wm]

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

[kb]

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?

[crouchingchicken]

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.

[haohuynh]

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

[segunlawal]

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.

[Leover]

Buen script en pocas líneas y muy funcional 👍

[somayaahmadi]

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?

[jorgepelatos]

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

[mahendrapal]

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

[RajaGiri_tvpm]

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

[LDomingos-gz]

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

[boredomindex]

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