Find Jobs
Hire Freelancers

Urgent Google Sheet Code Assistance

$10-30 USD

Completed
Posted 4 months ago

$10-30 USD

Paid on delivery
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](); }) }) }
Project ID: 37650757

About the project

3 proposals
Remote project
Active 4 mos ago

Looking to make some money?

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
Awarded to:
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
3 freelancers are bidding on average $25 USD for this job
User Avatar
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 in 1 day
5.0 (15 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
New City, United States
0.0
0
Payment method verified
Member since Jun 18, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.