Find Jobs
Hire Freelancers

comparing cell values in different sheets of the same spreadsheet

$10-30 CAD

Terminado
Publicado hace más de 5 años

$10-30 CAD

Pagado a la entrega
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]
ID del proyecto: 17697711

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,4
1,4
4 freelancers están ofertando un promedio de $54 CAD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
5,2
5,2
Avatar del usuario
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 en 3 días
5,0 (10 comentarios)
3,4
3,4

Sobre este cliente

Bandera de CANADA
Toronto, Canada
5,0
2
Miembro desde ago 12, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.