comparing cell values in different sheets of the same spreadsheet

$10-30 CAD

In Progress

Posted

over 5 years ago

$10-30 CAD

Paid on delivery

Need help with a simple Google Script. I have a Google Form that contacts need to fill out with their contact info. As they fill it out their email addresses are collected by default, which will be captured in column B of Sheet 1. Sheet 2 contains the list of email addresses who needs to fill out the form. The script needs to compare the responses against the master list. If someone's email address is missing from the responses list, an email reminder would be sent with details. Once the script is completed I would get an email letting me how many people have responded so far and how many more still need to. Link to the spreadsheet: [login to view URL]

Google App Engine

JavaScript

Project ID: 17697711

About the project

3 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

3 freelancers are bidding on average $59 CAD for this job

@kishu0079

Hello , I think I don't need to write about my self . I just want say that , This is so simple task that , I can complete this within 1 hour. I ensure you that, After seeing my work ,You will hire me for your all future projects. You will need to pay me after successfully completion of project and testing. Thanks Kishan

$30 CAD in 1 day

5.0

(7 reviews)

5.2

@umairmalik10

Hi, I've read project's description and seen the sheet you shared. I've few questions regarding this: Task is: - You will fill sheet 2 with email, first and last names. - Script will run and if any email present in sheet 2 is not in sheet 1, it will send reminder on that email. - Users will fill sheet 1. - When user fill sheet 1, how that user is removed from sheet 2? - At the end you will receive email about how many users filled the sheet. Right?

$111 CAD in 3 days