Find Jobs
Hire Freelancers

Google Sheet Modification with appscripts and triggers

$10-30 USD

종료됨
게시됨 약 5년 전

$10-30 USD

제출할때 지불됩니다
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: 18596755

프로젝트 정보

9 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
9 이 프로젝트에 프리랜서들의 평균 입찰은 $54 USD입니다.
사용자 아바타
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 3일에
4.9 (533 건의 리뷰)
8.4
8.4
사용자 아바타
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 10일에
5.0 (233 건의 리뷰)
6.6
6.6
사용자 아바타
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 1일에
5.0 (76 건의 리뷰)
5.6
5.6
사용자 아바타
am not a random bidder... Please ping me if you are interested with my proposal and share more detail.. thank you..
$150 USD 1일에
4.9 (28 건의 리뷰)
5.0
5.0
사용자 아바타
I have proficient knowledge of Google Apps Script and Google Sheets. I can do your work in 2-3 hours.
$15 USD 1일에
5.0 (1 건의 리뷰)
1.5
1.5
사용자 아바타
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 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello there I have expirience in making those kind of sheets. If Your interested in cooperation please contact me :)
$25 USD 2일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
London, United Kingdom
5.0
12
결제 수단 확인
8월 28, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.