comparing cell values in different sheets of the same spreadsheet

$10-30 CAD

In Bearbeitung

Veröffentlicht

vor mehr als 5 Jahren

$10-30 CAD

Bezahlt bei Lieferung

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

Projekt-ID: 17697711

Über das Projekt

3 Vorschläge

Remote Projekt

Aktiv vor 6 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

3 Freelancer bieten im Durchschnitt $59 CAD für diesen Auftrag

@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 Tag

5,0

(7 Bewertungen)

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 Tagen