Видео

In case it helps anyone else, if you want the "Append to current sheet" option, the file has to be a .csv file. It cannot be a .xlsx file. This drove me crazy for a little bit, so figured I'd mention it in case it helps anyone

Simple and to the point, thanks!

that is what i m trying to find since last mrning

This is the direction I'm going in and it works perfectly for Google Chrome on my PC browser, however, this doesn't seem to be working on my iPhone. It always takes me to Sheet 1. I'm trying to QR code some trees and collect data for each tree on a separate Sheet so, when I scan a specific tree, I would like to go straight to that Sheet. Your presentation was to the point, short and great thanks.

very informative secret formula thanks

I just had that issue recently in a shared file. Thanks for this video! I have a question: is there a way to create a cell in which an editor selects the country code based on the name of his/her country, like in a sort of drop down menu but that is already build within Google Sheets?

1...

Where is the sheet

what if a new player, say, comes 7th or something. how would the code sort that out?

I do all the steps and triples checked it and I’m still facing issues. (( #REF! )) pictures will not pop up.

That was great 😍

I really need help with a Apps Script I made. I need a pro to debug it. Anyone up for the challenge?

How do you change tab color on the Sheets App?

Thank you!! Very helpful and quick

Can i change my google form question based on the first answer ?

Thank you for this video 😍

HI, do i just type in the email of who it goes to i.e i own the sheet but want it to go to another email

Hello! Where can I see the Allow Access? It's not automatically showing when I hover my mouse in the cell. Thank you! Very helpful video

This is great. Better if you could share the template?

Thank you sir!

Nice! I used this with apple shortcuts

Something that can be really handy is to leverage the concept in this video and create an initial condition. If you use the $ before the column name and the row name on a given separate sheet used as a grading table it becomes trivial to have this be able to be drug down across a list of students. So I create something like what I have below ... then at the last minute remove the newlines so it pastes in correctly. The nice thing about this is that instead of manually pushing in the string of "A" for a letter grade, I'm instead referencing the value in the grading sheet I have. E.g., =IFS( P2/Q2*100>'Letter Grades'!$B$2,'Letter Grades'!$A$2, P2/Q2*100>'Letter Grades'!$B$3,'Letter Grades'!$A$3, P2/Q2*100>'Letter Grades'!$B$4,'Letter Grades'!$A$4, P2/Q2*100>'Letter Grades'!$B$5,'Letter Grades'!$A$5, P2/Q2*100>'Letter Grades'!$B$6,'Letter Grades'!$A$6, P2/Q2*100>'Letter Grades'!$B$7,'Letter Grades'!$A$7, P2/Q2*100>'Letter Grades'!$B$8,'Letter Grades'!$A$8, P2/Q2*100>'Letter Grades'!$B$9,'Letter Grades'!$A$9, P2/Q2*100>'Letter Grades'!$B$10,'Letter Grades'!$A$10, P2/Q2*100>'Letter Grades'!$B$11,'Letter Grades'!$A$11, P2/Q2*100>='Letter Grades'!$B$12,'Letter Grades'!$A$12, P2/Q2*100<'Letter Grades'!$B$12,'Letter Grades'!$A$13 ) This assumes that: - Column P in my grading section is the total score of the student. - Column Q is the total possible score And that my 'Letter Grades' sheet looks something like this: Min A 94 A- 90 B+ 87 B 84 B- 80 C+ 77 C 74 C- 40 D+ 67 D 64 D- 60 F 0

Not really sharing a tab. Just a quick way to create (and link) individual tabs to individual files which can then be shared. Not so great when you have many, many tabs.

I've been trying this all evening and continue getting the error message: TypeError: Cannot read properties of null (reading 'getLinkUrl') (line 5).

Walrus! 🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭🦭

Is it possible to show the count on the website?

Hi, Thanks for the nice xmas sheet. I got a problem while running the file shows a message: "Exceeded maximum execution time." and it does not show any detail. Would you please kindly instruct me what to do to fix this?

Thanks for the video! Very helpful. I like the privacy aspect of sharing just one tab. But is there a way for that tab to stay up to date with changes that may happen in the original?

accidentally hit delete button twice and the chip are gone.

I have a sheet but it has multiple tabs. I have a tab called Master and a 2nd tab called Sheet1. How do I pull the number from Sheet1?

concise and clear thank you!

How is anyone going to see the rest of the tab if it is that small?

event.value doesn't enable in my app script(its only show like this var checkboxValue =event.checkboxValue

Thank you so much for the learning

sold

yo thanks so much for this vid helped me big time thanks so much

Can you help write a script to achieve following? how can you get following time format via google sheet script. Current Format is: 12/4/2024 20:31:21 Format we are looking for: 12/4/2024 10:31:21 PM we are trying to use this one colum range like A1:A100. what script would get this done? Really would like your help.

Thank you this video showed EXACTLY what I wanted to do, create a quote/cover sheet for a new client's file

I love this video! Very clear explanation!

i dont have this option when i right click the sheet, not in the data tap

Can you restrict what users have access to it within your domain?

Great tip! what about years other than the current one?

this does not work

super - thanks very much - so useful - 💯

there is no file import in the mobile app

Is there a way to have a dropdown and have text in the SAME cell??

I'm able to get to the last step just like you did... but I get a tiny square and can't see the whole spreadsheet or move left to right. I"m in google just the same as the example

Great video but god what a terrible implementation by google. Add as many rows as you like any time, but if you got a narrow table prepare to do some clicking. The mind boggles.

it worked! thank you