This is great. I hope you could upload a video as well about inserting blank rows automatically after every change of data.
sheyanran
Hi! Writing from Paraguay. Your channel is gold. I can't say enough how you already helped me. My best wishes to you and your work
tecnoideas
Good stuff as always. I was wondering is there a way that if a cell says, “Approved” (C2) that it adds a data validation to reject input from the user (A2:C2). I want to make an request sheet system where I can approve requests. The user makes requests by entering in date and vacation and I approve. Once I approve it, they can’t modify it. Thanks!
ronaldjohnson_ita
Is it possible to create a drop-down and enable multiple selections in Google Sheets?
findthetruth
thank you so much and many of your tutorial videos have helped many people including me you are amazing
yuttanak
Thank you!
If may I suggest a topic... have you thought about creating a series of videos about a request workflow with multiple levels of authorization?
I can imagine that it will involve: google forms, sheets, apps script, and gmail.
lauraa.
I have created a from recently by visual studio code, but I have only a single problem. I can't make a reset function when the form is going to be submitted. Which means the filled gaps will remain with the same information without being reset. I would love to share with you my whole code, just add this function to there. Waiting for your kind response. Thanks in advance.
findthetruth
Could anyone please let me know what to type into the filter column. What is the entire function that I need to type in
marykmendes
i was try but it said "Exception: Those rows are out of bounds." what can i do to fix it?
anaklokal
Can you do a Google query to only select and show rows where there are no blanks (on another tab) as an alternative solution?
lostmamo
Does anyone know how to keep the date data from coming over as a number value when you use concatenate? IE. date 08/12/2021 converts to 44420 using concatenate.
ebx
I’m looking for videos that can help me :) if i try to explain what i’m doing it simply, i would say that i’m studying 100 sentences that i want to memorise and they are not in numerical order.
If i studied sentence 5 i want to put 1 in A5 and if i studied sentence 60 i want to put 1 in A60. “1” means i practised once. I want to see sentences i haven’t practised yet or the least times to study them for the first time. I don’t want to spend too much time for the same sentences. Which video should I watch?? ( plus, if there are so many sentences then i would need to scroll all the way down to put “1”. : Sentence 1000 => A1000)
leobae
How can I subtitute text "AA" from "AABC" in column A?
GazeKuNG
Ah, it's so hard for me to understand how to work with ranges and selection in JavaScript instead of VBA(( There is so many small scripts i have written in excel that don't know how to reuse in sheets
unhxwqj
You are amazing bro. Always making great videos.But, I have a suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
findthetruth
Hi, Nice idea but only works if there are less than 8 columns in the table. If there are more columns, the macro will delete some data.
