Find Jobs
Hire Freelancers

comparing cell values in different sheets of the same spreadsheet

$10-30 CAD

Completato
Pubblicato più di 5 anni fa

$10-30 CAD

Pagato al completamento
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]
Rif. progetto: 17697711

Info sul progetto

4 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hi, I can fulfil the task within 1-2 hours 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]
$41 CAD in 1 giorno
5,0 (2 valutazioni)
1,4
1,4
4 freelance hanno fatto un'offerta media di $54 CAD
Avatar dell'utente
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 giorno
5,0 (7 valutazioni)
5,2
5,2
Avatar dell'utente
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 giorni
5,0 (10 valutazioni)
3,4
3,4

Info sul cliente

Bandiera: CANADA
Toronto, Canada
5,0
2
Membro dal ago 12, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.