Complex issue explain nicely 👍

This seems to be the most helpful video I've found for what I'm trying to do. However, can you identify what are the parts to the script that I should adjust based on my spreadsheet? I've never used Apps Script or written any type of script so I feel a bit lost. Thank you

Thanks for the amazing tutorial, but is it possible to input an number there that will automatically notify the parents that their children safely arrived in school?

Thank you very much for the video; it was very helpful for me. However, I’d like to ask, how can I make each product row automatically have a different row color?

I tried this using a "test" sheet, and it worked wonderfully. HOWEVER, when I try to replicate the script on the tab I need, it doesn't work. I changed the sheet name in the script, left the column the same (it is the same), and everything else as shown here. It doesn't work. What am I doing wrong? Edited to add that I am using a "table," not a range.

Hey this is as quality work as I've seen, very nicely done. Where did you grow your expertise?

I typed in =date(c3,month(c2&1),1)-(weekday(date(c3,month(c2&1),1))-column(A3) and I am getting 12/29/2024...I can't figure out why when I have 2025 in the year and January in the month. Can anyone help me?

Thanks a lot !!!

#REF - Reference does not exist? I copy/pasted the script, saved it.. and I get #REF

love the step-by-step, but unable to afford Document Studio -- I guess the community would really benefit from a free alternative to that

Hi there! I am a teacher who created our after-school CICO spreadsheet using the lambda functions you shared in the video. It worked great until the last week of December. When we returned from winter break, the timestamps were no longer static. Why do you think this is happening? Can you please help me figure out how to fix this?

I might be late to the party here since the video was poster a year ago... I've been trying to figure out how to get the check box to have the ✔ if the task is done and ✖ if the task is not done. Any idea how to achieve that?

unknow command QRCODE plz help

How do you prevent users from breaking the dependent dropdowns?

I've entered the lambda functions as he did for the start and end times. However, every time a checkbox is checked, both the start and end times update to the current time. I've started over so many times. I cannot locate my error. What did I do wrong?!

Does this still work? I copied it exactly and it used to work fine but now the timestamp updates whenever I make any change to the google sheet

top!

top!!!

top!!!

top!!!

it's very cool!

Hi! Thanks for the video. When I first created this, it appeared to work just fine. Now, every time the workbook is opened - the times change (as if the Now formula is not saving prior inputs). Any insight on how to resolve this issue?

Hello I'm having a problem withe the time At first it was working right but now It is changing I delited it all and restarted but the problem still the same Can you please check it and help me

I hate google sheets.

Hi! Trying out the formula for multiple calendars in the same sheet, however, I can't seem to figure it out for the second month. Can you explain the purpose of the "column(A3)" part of the formula? It changes as I change the column, but I can't seem to understand why.

function GetURL(rangeInput) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getRange(rangeInput); var values = range.getRichTextValues(); var results = []; // Loop through each row in the range for (var i = 0; i < values.length; i++) { var row = values[i]; var rowResults = []; // Loop through each cell in the row for (var j = 0; j < row.length; j++) { var richTextValue = row[j]; if (richTextValue) { var url = richTextValue.getLinkUrl(); rowResults.push(url ? url : "No URL Found"); } else { rowResults.push("No URL Found"); } } results.push(rowResults); } return results; } Far Better Formula then any of them Thanks me later

Great video, learned lots of new tricks. Im just having 1 little issue. I followed step by step and the formula for the dates to update with months and year isn't working properly. No matter the month, the 1st day stays on monday. Idk what Im doing wrong 😩

Super helpful! Thank you very much, this actually solved 2 problems I was having, by teaching me about the Query function. So thanks for hitting 2 birds with 1 stone. 😉

So clever

Hi very helpful video but I am stuck at 5:54 - how did you drop down the rows to create space for adding in extra information?

What can I do if I want the QR code to say if they are in the list or not

How can I filter a checkbox and have the cell appear in the filter results instead of True or False?

How to stop students proxy other students attention

Thank you, could you make a tutorial, how to create filter and export csv in Appsheet?

On June 2025, my calendar starts on the 2nd. How would I make it start on the first?

Hi.. nice video.. but I have no function IFNO.. is there any other formula I can use?

help :/ at 3:20 , i have the same formula and when I drag out the days across the week, it goes from 29 (Sunday) to 26 (Monday). I have my Month set to Jan and year to 2025

How to insert an image into a QR code step by step? Please explain. Also, the Google QR code infographic link is not visible.

Hey just a quick question at 20:33 you managed to fix your REF error by adding more rows, but mine comes up with an error for the next collom instead, or if it is about the rows a new row is only a tempowary fix or doesnt work at all. Is there anywau to fix this, it occurs when i try to add an event on, even when i have multiple separate rows for a day, it just seems to be an issue with 'overwriting data in ___' and im not sure how to fix it any advice?

I would love to know how to change the frequency to a bi-weekly. monthly, or yearly option.

How can I make a copy of the spreadsheet without breaking the formulas - been struggling with that for a while - HELP!

This is very good but in the first section you explain how to get +0 but completely skipped how to solve the problem (+1) for the 3 rows showing the issue. I’m a developer and I know that TRUE will equate to 1, but I’m guessing many viewers will want that info, which you omitted. There’s also no explanation of why +1 solves the problem. Why does 4-20+1 solve the problem?

this can work in Microsoft excel right?

Thanks, this is great, when are we going to deep in Fequency, birthdays, integration google calendar?

great video! however I’m stuck on the first part - how did you change the numbers to show from the 4,000’s to count chronologically from 1? I see you highlighted all the cells but not sure what you clicked.

I work day shift and Night Shift sometimes in the same week also want week number

This is awesome, thank you! One issue I've encountered: when adding an offset for using Monday as Day 1, this sometimes creates the bug that you lose Day 1 from the calendar altogether, and the month starts on Monday, Day 2. I think we saw this in your vid for Sep 2024, any ideas how to get round this?

Hi Hash, I am syncing 12 sheets but the last sheet data is not coming in the query. But when I used query for just that sheet its pulling data. Can you please help? or can someone else?

for people who are trying to adopt this to use for labeling: you need to change the query so that it looks like =transpose(QUERY(B:C, "SELECT C WHERE B = '"&referenced_sheet!K2&"'", B1:C1)). In the formula, B1:C1 are your headers. Because if you don't use headers there is an issue with cutting the list in our dependent list by one on each following row until you are left with "N/A". That way, let's say you choose the labels "cats" from column C and you will have your options from column B "white, calico, red,.." on each row which is useful for labeling