Видео

Good to understand, its easy.

Hi sir I am maths teacher I had created the marksheet of students only maths subject where I had taken multiple test but everytime whenever I want to make that I have to search the students name first then in next column I write there marks So my question is'' is there an any formula where I write there name and there marks so it's automatically add in column?"

Great, Thanks

Apps Script Code for sending Birthday Wishes function sendBirthdayWishes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var today = new Date(); var todayDayMonth = today.getDate() + "-" + (today.getMonth() + 1); for (var i = 1; i < data.length; i++) { if (data[i][0] === '') { continue; // Skip empty rows } var name = data[i][1]; // Adjust column index based on your sheet var dobCell = data[i][2]; // Date of Birth column var dob; if (typeof dobCell === 'object' && dobCell instanceof Date) { dob = dobCell.getDate() + "-" + (dobCell.getMonth() + 1); // Format DD-MM } else if (typeof dobCell === 'string' && dobCell !== '') { var dobParts = dobCell.split("/"); dob = dobParts[0] + "-" + dobParts[1]; // Format DD-MM } else { continue; // Skip rows with invalid or empty Date of Birth } if (dob === todayDayMonth) { var email = data[i][3]; // Email column var subject = "Happy Birthday " + name + "!"; var message = "Dear " + name + ", Wishing you a very Happy Birthday! Have a fantastic day! Best Regards, Ajay Anand"; MailApp.sendEmail(email, subject, message); } } }

Bro here shows value...not generated to link

very nice explanation, really appreciated

I could hug you right now!!!! Omg!! You saved my life. i have been struggling. Thank you.

Makes sense, really love that😂❤

Awesome, Thank you Bro

Really nice

Thank u Sir , amazing videos ❤

thank you for such simple and understandable explanation

Really really appreciate your effort. This is superb. Is there any way to connect their attendance ledger of the month along with payslip ...? Please make a video on it as well

I'm not able to do . I is showing that whats app web is external site and blocking me. Plz help.

I don't know what is this and why all are saying thanks?

Very useful, sir. Can't thank you enough.

Just fantastic

This is wonderful and very creative. But is it possible to change to date instead of the names?

Can u please share any full project for data visualisation with excel , sql

Hi Ajay I have a group of Golfers 28 to 36 max in an Excel sheet I would like to have every week each player from the foursome cannot meet any one that he already played with for nine consecutive weeks wondering if it is easy way thanks

How to get text in formula cells.. please help

Thank you very much

Hi Ajay, I have followed your steps, however I have an error where it stated that 'Do without Loop' which I think it told me that I did not put loop word Could you please advise how I can fix this? Thank You and appreciate your response

if update field inactive what i do

Very very clever, fabulous

Wait... Why false?

Hello, can you please explain how did you have saved only the table and not other information in the spreadsheet?

Sir i have a file i wanted to create a program i add another file for match some digits if some one match then highlights and add there new file Please guide

Thank u so much! God bless u! :)

"phone number shared via url is not valid" please resolve this issue

Malayaiiiiii

Short video and very understood 👌

Hi thank you for this excellent information's, may i ask you if i want to send and image through WhatsApp let us say invitation card, is it possible please thank you

thanks..

Thanks Ajay for creating such informative videos, it's really helpful for beginners like me

How can find number in same mode

Hi, If it is .csv file. how to run the code

goated video, thank you

I want to calculated 01-01-2024 01- 02- 2024 ? 01- 03-2024 ? 01- 04-2024=? How many days bitven

This video made me think creating dashboards is very easy 😉 Thanks for Ajay 👏👏

Thank you sir

Sir Sumifs sai nikal jate yea value

mine has refused please

❤

dataset for sale..wah nice

Thank you...problem solved

Awesome.. Very easy and helpfull

Thank u...in the customs option how to enter page 1/5..page one of page 5

Wow

Very informative Video 👍🏼