Find Jobs
Hire Freelancers

Google Sheets, two-way sync between range sets (same document, separate sheets)!

$30-250 USD

Abgeschlossen
Veröffentlicht vor etwa 1 Jahr

$30-250 USD

Bezahlt bei Lieferung
Basically, I'm looking to find out if there's a formulaic or script solution to sync between two data sets existing within the same document but on separate sheets. This is a social media content calendar planner. I've created Checklists for each month - tasks for social media managers to accomplish re: the month's content planning, scheduling, etc... I've also created a separate sheet that contains a Gantt Chart. This would contain a master-list of all of the checklists across each month and platform. Instead of ImportRange, however, I'd like to see if there's a possibility to create two-way syncs between the sheets. That way, any edits to the monthly checklist will be reflected on the Gantt Chart, and vice versa. I was looking into combining the Query and Import Range function to accomplish this. I was also looking into utilizing an OnEdit Script, but I'm not versed in script work AT ALL. I've attached screenshots, with the ranges in question highlighted in orange. Would love to see if this is possible! Many Thanks, Katie
Projekt-ID: 36526739

Über das Projekt

17 Vorschläge
Remote Projekt
Aktiv vor 1 Jahr

Möchten Sie etwas Geld verdienen?

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
Vergeben an:
Avatar des Nutzers
$0 USD in 1 Tag
4,9 (61 Bewertungen)
6,3
6,3
17 Freelancer bieten im Durchschnitt $167 USD für diesen Auftrag
Avatar des Nutzers
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day
$120 USD in 1 Tag
4,7 (31 Bewertungen)
5,0
5,0
Avatar des Nutzers
Hi Katie, greetings from Tushar!! I am interested in taking up your google sheet project. I understand that you are looking for a solution to sync between two data sets existing within the same document but on separate sheets so that any edits made to data on one sheet would be reflected on the other sheet and vice versa. I would like to tell you that I can help you with this by using google app script to achieve what you are looking for. I am a spreadsheet expert and have hands on experience of working with google app script, google sheet, APIs and google forms and have done few projects previously using google app scripts and google sheet functions and so I believe I can surely help you as well. Let's connect over chat to discuss further on this. Looking forward to hear from you. Thank you.
$110 USD in 4 Tagen
5,0 (14 Bewertungen)
4,7
4,7
Avatar des Nutzers
I propose to create two-way sync between two data sets in Google Sheets using Query and ImportRange. I have extensive experience and am confident that I can complete this project to your satisfaction for $150 within 2 days. I am ready to start working right now. Contact me if you have any questions. Sincerely, Osama
$150 USD in 2 Tagen
5,0 (6 Bewertungen)
4,0
4,0
Avatar des Nutzers
Hey Katie , I can definitely help you setup an on edit script for a two way sync between sheets. We are a team of trained  professionals with years if experience in MS excel , Google Spreadsheets, VBA Macros and App scripts. Hit us up and we can talk in detail. Regards, Nikita and her team at Affiliation
$149 USD in 7 Tagen
5,0 (4 Bewertungen)
4,0
4,0
Avatar des Nutzers
Hi, I have gone through the Job details and am interested in taking it up. I would like to contact you for more details, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$150 USD in 3 Tagen
5,0 (5 Bewertungen)
3,0
3,0
Avatar des Nutzers
Yo! I am professional Google App Script computer programmer with skills including Google Apps Scripts and Google Sheets. I am Angular, React, ASP.NET, C#, VueJS, Google Apps Script, CMS I am a FULL STACK Developer working on Google Apps Script, React, Angular, VueJS, Node.JS, ASP.NET CORE, and ASP.NET MVC, C#. My experience and Expertise are as follow:=========== Node.JS, ReactJS, AngularJS, VueJS, C#, Angular2,4 and 5, ASP.NET CORE, ASp.NET, and VB.NET, MVC, Entity Framework and Xamarin Bootstrap, Kendo UI, JavaScript, Ajax, jQuery ,WinForms, HTML5, XML, CSS3 , KnockoutJs, DataTable JS, Extension JS, Node.JS, TypeScript WCF, WPF, SCSF, WSSF and Web/Win Services, Amazon web services Infragistics, Telerik Controls, Crystal, Think Geo Map Suite, GIS Reports, SQL Server, MS Access, MYSQL, MongoDB, No SQL DB, Azure, BizTalk, AWS, S3 Visual Source Safe, SVN, Dream Viewer, SQL Delta, VS online nopCommerce, Able Commerce and Volusion Cross-Platform: Xamarin, Ionic Kindly let me know if you need detailed information on the above-listed projects with their features and cost estimate. Look forward to working with you with the best of my services and attention. Please contact me to discuss more about this project. Thanks & regards
$250 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi there! My name is Ansaf and I am a highly motivated and results-driven virtual assistant with extensive experience in providing administrative support and project management services. I understand that you are looking for a solution to sync between two data sets existing within the same document but on separate sheets. This is a social media content calendar planner for a client and they have created Checklists for each month's content planning, scheduling, etc. However, they would like to see if there's a possibility to create two-way syncs between the sheets so that any edits made to the monthly checklist will be reflected on the Gantt Chart and vice versa. I have been looking into combining the Query and Import Range functions to accomplish this two-way sync. As well as utilizing an OnEdit Script to make sure there are no issues along the way.
$217 USD in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi Mate Katherine M., Good evening! I just checked your attachments and understands what you need exactly. As you can see in my profile I am an expert web engineer not just a normal developer with skills including Google Apps Scripts and Google Sheets. I checked for your project and interested in your project. I am skilled full stack computer programmer with skills including Website Design, MySQL, PHP, HTML and JavaScript.
 I have done several complex projects and provide continuous maintenance support. My goal has always been to provide reliable and efficient to my clients and so far I have been quite successful. I won't delay your project and will keep you updated with constant feedback and status of the work My Full Stack Development Skills 1. Frontend: Front-End HTML5, CSS/CSS 3, JavaScript, 2. Server Administration: Amazon Web Services, Digital Ocean, LAMP, Cloud, Apache, Apache Tomcat, NGINX. 3. Backend: PHP, GoLang, Ruby, Python, Laravel, CI, CakePHP. 4. Databases: Mysql, Oracle, PostgreSQL, MS SQL, SQLite, MongoDB. 5. Testing: Manual & Automation testing. 6. Frameworks: Angular Js, React JS, Symfony2, Laravel, Silex, Spring MVC, Rails, Django, Pyramid, Protractor, Selenium, Blockchain, Etherume, Vuejs 7. UI/UX: Photoshop, Sketch, Zeplin, Invision, Moqups. Type of projects we have delivered to our global clients: a. Enterprise Software Development, b. CRM Development, c. SAAS Product Development c. Web/Mobile Based Application development. d. All CMS website: Wordpress, Magento, Joomla, e. HRMS Software f. Multi-level Marketing (MLM) with crypto payment gateway f. E-commerce installation and customization g. Crypto Exchange Development I'm ready to start your project and I can start from now on. Please send a message to discuss more regarding this project. Feel free to contact us to discuss your project
$155 USD in 4 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
**Hello there! My name is Muhammad and I am part of the team at Professor X Corporation. We specialize in providing digital marketing services to businesses. We understand that you are looking for a solution to sync between two data sets existing within the same document but on separate sheets. With our expertise in Google Sheets, we are confident that we can provide the best solution for this project. Our team has extensive experience in handling and optimizing social media pages, websites, and LinkedIn optimization. We also have expertise in content creation and optimization. Our services include social media marketing, email marketing, content marketing, PPC advertising, conversion rate optimization (CRO), online reputation management, website design and development, analytics and tracking, SEO services (e.g. keyword research and analysis) as well as content creation and optimization. We take pride in providing our clients with a customized approach to digital marketing through our commitment to transparency and communication. This includes monitoring and analyzing Google algorithm updates as well as providing content creation and optimization services related to competitior analysis tracking.
$140 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Louisville, United States
5,0
2
Zahlungsmethode verifiziert
Mitglied seit Jan. 19, 2023

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.