Find Jobs
Hire Freelancers

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

$30-250 USD

Concluído
Publicado há 12 meses

$30-250 USD

Pago na entrega
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
ID do Projeto: 36526739

Sobre o projeto

17 propostas
Projeto remoto
Ativo há 1 ano

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
$0 USD em 1 dia
4,9 (61 avaliações)
6,3
6,3
17 freelancers estão ofertando em média $167 USD for esse trabalho
Avatar do Usuário
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day
$120 USD em 1 dia
4,7 (31 avaliações)
5,0
5,0
Avatar do Usuário
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 em 4 dias
5,0 (14 avaliações)
4,7
4,7
Avatar do Usuário
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 em 2 dias
5,0 (6 avaliações)
4,0
4,0
Avatar do Usuário
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 em 7 dias
5,0 (4 avaliações)
4,0
4,0
Avatar do Usuário
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 em 3 dias
5,0 (5 avaliações)
3,0
3,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
**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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Louisville, United States
5,0
2
Método de pagamento verificado
Membro desde jan. 19, 2023

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.