Find Jobs
Hire Freelancers

Urgent Google Sheet Code Assistance

$10-30 USD

Terminado
Publicado hace 4 meses

$10-30 USD

Pagado a la entrega
Compare two different columns and append the first column with anything different BASED on criteria I have the following code but its missing the criteria portion. I have a source and a target . The Source I want to look at Sheet 1 column A but based on if column B if its "Not Active" and then go to sheet 2 which is the target and add to column A as long as its not in column a for the target sheet. Here is what I have so far but I dont know how to make it based on the criteria "not active" and i also need this to run ON EDIT so when the source sheet is updated it runs. function updateSheet() { let ss = [login to view URL]() let sourceValues = [login to view URL]("Customer Contact List").getRange("a8:a1000").getValues().filter(String) let targetSheet = [login to view URL]("Main") let targetRange = [login to view URL]("a8:a"); let targetValues = [login to view URL]().filter(String) let diff = [login to view URL](sourceValues) [login to view URL](); targetValues = (diff && [login to view URL]) ? [login to view URL](diff) : targetValues; [login to view URL](1, 1, [login to view URL], targetValues[0].length).setValues(targetValues) } [login to view URL] = function (array) { let that = this; return [login to view URL](function (r) { return ![login to view URL](function (x) { return [login to view URL]() === [login to view URL](); }) }) }
ID del proyecto: 37650757

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 4 meses

¿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
Ciao Momkaa Y., I am Luigi, an Excel expert with over 5 years of experience. I have carefully read your project requirements and I am confident that I can assist you with your urgent Google Sheet code assistance. Based on your description, you have provided a code that compares two different columns and appends the first column with anything different. However, you mentioned that you need to add a criteria based on the "Not Active" condition, and you also want the code to run on edit when the source sheet is updated. To achieve this, I will modify the existing code to include the criteria "Not Active" and implement the on edit trigger. Here is how I will approach the project: 1. Get the active spreadsheet and define the source and target sheets. 2. Retrieve the values from the source sheet column A, considering the "Not Active" condition. 3. Retrieve the values from the target sheet column A. 4. Compare the two sets of values and identify the differences. 5. Clear the content of the target range. 6. Concatenate the differences with the target values. 7. Set the updated values to the target range. I believe that discussing the project in more detail would be beneficial to ensure the best quality deliverable. I would appreciate it if we could start a chat to discuss your specific requirements and any additional details you may have. Thank you for considering my proposal. I look forward to discussing the project further with you. Thanks, Luigi
$10 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
3 freelancers están ofertando un promedio de $25 USD por este trabajo
Avatar del usuario
Hello. I read your requirement i will do that immediately. Please come on chat we will discuss more about this. I will waiting your reply.
$35 USD en 1 día
5,0 (15 comentarios)
3,9
3,9

Sobre este cliente

Bandera de UNITED STATES
New City, United States
0,0
0
Forma de pago verificada
Miembro desde jun 18, 2013

Verificación del cliente

Otros trabajos de este cliente

Google Sheets Coding Assistance
$10-30 USD
¡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.