Відео

So visually this works, however I need an actual empty cell because my spreadsheet uses a Google Function b=GOOGLEFINANCE(B28&":"&"SDY", "name"). The B28 is the exchange on which the security is listed. However certain named securities don't have an exchange and so the B28 cell as above must be blank. After playing around it seems the single quote works in my case.

This was my first time using App Script ever and it worked perfectly. Thank you so much for the great tutorial!!! Lifesaver

is it possible to do this without making a new table

Awesome video on the google sheet that you shared i noticed that you get 18.18 for the calculated gst (this is for the amount of $200) and im getting flat $18. Without the cents and is the same code, any idea why that happens?

Is there any way to have one person report to several people? I haven't found a workaround for this... It seems like many people can report to one manager, but one person is not allowed to report to more than one person... Thanks

helpful, thanks!

I need help please. I am needing to add code to the existing macro in this file. The new code should perform a Find & Replace on the entire columns of R, W, and AB. It should Find "PAY" (match Case and Entire Cell Contents) and Replace with "Paid". This new Find & Replace code should run before the existing macro code runs. docs.google.com/spreadsheets/d/1igKtYmkVo3wVaGF9E1RBTkikSMyp8aneMUQRN8ZOWOM/edit?usp=drivesdk

I cannot get this to work to reverse a block of rows/columns as in your first example, I keep getting a value error, not sure what I'm doing wrong.

This worked great but there is a black line underneath the image (I am assuming Google showing users this is a linked image), is there a way to remove this, is this something new they have introduced or have I done something wrong here?

Thanks again for these videos, works great!

Hi Scott, by Aby chance do you know How to Schedule a message to be sent Every day at 6:00 am, this in order to send Threads every day in a Space chat

Thats a PERFECT asnwer!!! thanks!

Works great but what if you want to be able to keep pasting this range to the next available row below the pasted data in the destination sheet? So in other words the destination sheet becomes an archive. Hope this makes sense.

colors of card are not coming in my case else everything working

Two issue I faced..1. color of cards and second in single column formula is not working as it syas "array result can not expanded as it overright data in 16" ,could you suggest solution?

My problem is when the user delete the checkbox. Converting the data into a "tables" format will fix this problem. However, in a table format, I can no longer have data validation for an in between dates for a date column. :-{

Hi my friend, I followed all the steps you indicated, but I can't find the application from Google Chat. What could be the problem? best regards

Amazing Video but can we upload a document in input sheet and save it

Great tutorial and really helpful, Would it be possible to have a dotted line between 2 functions kinda of a indirect reporting if you know what I mean? thanks

Thank you so much for your help man, very surprised how this concept is hard to find online but you made it seem easy

Is it possible to do it using Apps Script ?

Thank you so much for this tutorial & script. Made my life so much easier.

Can you make it so the name is pulled from a name in a cell?

It has been very useful to me, but I would like to make a top 8 of the results obtained, not only the most common, but a top 8 of the most common. Exactly, I would like to have 2 columns, one that shows me the top 8 of the most repeated cells and then another adjacent column that shows me in parallel how many times the adjacent cell is repeated in the original column. I don't know if this can be done in Google Sheets, if so, I would appreciate anyone who knows how to do it.

Brilliant

How would i do a find and replace across all sheets? Ive gotten as far as below - but it only updates one sheet, not all of them and havent been able to figure out how to make it replace across all sheets: function replaceCombinedText() { const searchText ="StaffCareer" const replaceText ="Staff Career" const sheetName = "Sheet1"; const rangeLoc = "A1:Z1000"; const ss = SpreadsheetApp.getActiveSpreadsheet (); const sheet = ss.getSheetByName(sheetName); const range = sheet.getRange(rangeLoc); range .createTextFinder (searchText) .matchEntireCell(true) .replaceAllWith (replaceText) }

Excellent info/how-to/class! - worked perfectly on my new Google Sites. Greatly appreciated, wish you the best Scott...take care and enjoy Life 🙂

THANKS A LOT

You are a life saver! Thank you!

im trying to create an add-on that will "listen" for a create event in google calendar, and when an event is being created and the participant field has been filled the addon popup will appear (after sending the participant email to a third party API) with insights about the participant (info from said third party API) is this possible with google workspace add-ons? will this course help me create this idea?

Instead of naming the copied file with an asterisk, how would I pull a name from list in column A of a different sheet to rename the new copy? For example, I have 100 names in column A on a sheet called "Names", and I want to copy a different sheet called "template", so I want to end up with 100 copies of my template, each renamed with a name from the 100 rows in column A of my "Names" sheet. How can I change the script code to do that?

so hard finding a good video these days,thank you❤

date/time is a great way to ensure uid's never get duplicated. I'd love to have say a customer like George Smith followedd by other names where each gets a uid of first 5letters of name paired with date/time. For example. as I ad names to column 2 column 1 populates with georg20240828_22-24 or if tom lee then tomle20240828_22-25 etc. Thanks for this video!

is there a way to not collect the date and time along with the email? I just want the inputs. thanks for the tutorial!

can we update based on latest image on the folder

Hi Man, I followed your instruction.. but I can't find publish to the web option on google drawing.. can you help me?

Super helpful tutorial. Just like how your list had two results at the end, 'puzzling' and 'cryptic', my data returns two results. I'm creating a list of sales throughout the year and trying to find the sales rep with the most sales in a particular month. One of the months has a tie, but I only want to see one rep name because I'm listing the top sales rep result in a column that corresponds with another month column. The two reps that tied in June are causing problems with July. Is there a way to ignore the other top results and only return one? Hopefully, this makes sense.

Did you use any special formatting to create the spacer lines? Or just made them a dark grey?

This video really helped me understand Query - thanks for helping me sleep at night! 🙂

Script is gone

What do you do if you are given a time delay when filling in the next data?

Easy Conceptual Comprehensive Doable Thanks 😊

Thank you for sharing this!! I'm gonna check the other videos too! I might have a use for those but I still don't know how could I adapt it for my google sheets... I'll try to play with those codes 😆

how to findAll the range which has date less than 19-Feb-2023 in your column C

What am I doing wrong? Here is what I've put in, but the Extras option is not showing up function onOpen(){ const ui =SpreadsheetApp.getUi(); ui .createMenu("Extras") .addItem("Sort Tab Asc", "tabSorter,ascending") .addItem("Sort Tab Desc", "tabSorter,descending") .addToUi(); }; const tabSorter={ ascending: function(){ this.sortTabs(true)}, descending: function(){ this.sortTabs(false)}, /** * Naturally sort tabs. * Sparam {boolean} inAscending - if true, then sort ascending, false sort descending */ sortTabs: function(inAscending){ SpreadsheetApp.getUi().alert("Is ascending:" + inAscending) } }

Is it to early on our relationship to say I love you? Thanks a lot for this video! Running (or trying to) a board game library in our small town. Don't know how to manage databases, so just making a lending system to keep track of stuff with google sheets. I wanted to make it as simple to users as possible. So, now they don't even need to fill in the date! Thanks a lot for the video!

I've been enjoying your videos. Thank you for making them. I have a question about cells that break data validation. Is there a Google Sheet formula that returns boolean when cells in a range breaks data validation? I'm working on a sheet where sometimes, cells can have the red triangle appear if those cells are no longer valid for data entry.

Thank you for making this video. It’s very helpful :)

Thank you very helpful!, I need to find and replace on formulas, how can i do it in apps script?

what if the folder is inside folder?