Find Jobs
Hire Freelancers

Google Sheet Modification with appscripts and triggers

$10-30 USD

Cerrado
Publicado hace más de 5 años

$10-30 USD

Pagado a la entrega
I need an expert in google sheet scripts (Excel VBA) to add triggers and modifications to my workbook. Must know how to work google appscripts. To Do 1. Redo Protected cells and clear cells 2. On AM Sheets Col BO1 I need a triggered function that copies the VALUES ONLY from E1:AS47 (Triggered 9am of the same day). So 9am of Monday, MonAM BO1 gets VALUE COPIED to MonAM E1:AS47. Continues on to next sheets the next day 3. On PM Sheets Col BO1 I need a triggered function that copies the VALUES ONLY from E1:Z47 (Triggered 9pm of the same day). So 9pm of Monday, MonPM BO1 gets VALUE COPIED to MonPM E1:AS47. Continues on to next sheet the next day 4. Triggered lock function similar to previous sheets made. At 11am of Monday, MonAM locks and MonPM becomes editable. At 11pm of Monday, MonPM locks and TueAM becomes editable. Editable sheet with green color for easy viewing 5. On FriPM trigger A copy of Workbook is made. Name of Workbook is Workbook Name + Cell 2MonAM!B1. Data is cleared on Sheets 2MonAM to 2SunPM 6. On 2FriPM trigger A copy of Workbook is made. Name of Workbook is Workbook Name + Cell MonAM!B1. Data is cleared on Sheets MonAM to SunPM 7. On MonAM!B1 & 2MONAM!B1; is it possible to show the week that this sheet falls on eg. if it falls next week then MonAM!B1 should show "Jan28 to Feb3" (Mon to Sun format), and 2MonAM!B1 "Feb4 to Feb10". Ofcourse this has to change week per week so i suppose this can be added to part of the trigger Remove 1. Email Function and Button to send request request
ID del proyecto: 18596755

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 5 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
9 freelancers están ofertando un promedio de $54 USD por este trabajo
Avatar del usuario
Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. Please ping me for more discussion.
$120 USD en 3 días
4,9 (533 comentarios)
8,4
8,4
Avatar del usuario
Hello, I am an Excel coder and I already finish 1 google sheet script with triggers to use on phone/tablet. I think I can do this task for you. Contact me and I can show you my result for a look. Thank you.
$30 USD en 10 días
5,0 (233 comentarios)
6,6
6,6
Avatar del usuario
Hello, It would be my pleasure to create the scripts for you and assign triggers to them. Actually I will show you how to add/modify triggers yourself as this is very easy. Please open a chat with me if you are interested. Kind regards, Sorin
$50 USD en 1 día
5,0 (76 comentarios)
5,6
5,6
Avatar del usuario
am not a random bidder... Please ping me if you are interested with my proposal and share more detail.. thank you..
$150 USD en 1 día
4,9 (28 comentarios)
5,0
5,0
Avatar del usuario
I have proficient knowledge of Google Apps Script and Google Sheets. I can do your work in 2-3 hours.
$15 USD en 1 día
5,0 (1 comentario)
1,5
1,5
Avatar del usuario
Hi sir I am studying artificial intelligence in kings cornerstone international college Chennai in association with RMIT UNIVERSITY, Australia I can do this project best Waiting for your message sir.
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, Google app script is pretty straightforward and I have worked on it quite a number of times. May I know the file that you want me to work on? I've been working on php, java script, python scripts and linux administration for more than 11 years. I always believe in giving my best in every single project and will ensure that you'll get top quality work from me. I hope to work with you and if you have further questions, do feel free to message me. Regards, Abel
$20 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Let's do it this way. You share the sheet with me, and I will do the script work and share it with you. You will not own the script until you pay me. This way, you can be satisfied with what you see, and then pay me. Also, I will need to do all the options you have asked for and it will take much time than you expect. The budget is short, to cover the freelancer project fee as well, I will need at least $55 in one milestone. And you can release it when you are satisfied with the file. Thanks Qunson
$55 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello there I have expirience in making those kind of sheets. If Your interested in cooperation please contact me :)
$25 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
12
Forma de pago verificada
Miembro desde ago 28, 2015

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.