Encerrado

repair script issue on my google sheet and write one additional script

We use a google sheet to keep track of projects. this project is to resolve two issues with our current google sheet.

Issue #1 we currently use function =if(isblank(D5),0,TODAY()-D5) to let us know when a project was started. As we add additional lines we sometimes forget to copy the function to the new lines.

Issue #2

One of the columns adds a date when data is entered into a different column. The script was working but is no longer working.

Diagnose and repair script so.

Write script so that we no longer need the function.

Here is part of the script we currently use:

//////////////////////////////////////////////////////////////////////////////////////////

//ANDREW: Start

if( [url removed, login to view]() == "Order Tracking" ) {

var r = [url removed, login to view]();

if( [url removed, login to view]() == 17 ) { //checks the column

var thisCell = [url removed, login to view](0,0);

var nextCell = [url removed, login to view](0, 4);

var indicatorCell = [url removed, login to view](0, 0);

if( [url removed, login to view]() === 'x' || [url removed, login to view]() === 'X' ) { // = to x OR X

[url removed, login to view](new Date());

[url removed, login to view](84,130,53); //sets background to green

}

}

}

//ANDREW: Finish

if( [url removed, login to view]() == "Order Tracking" ) {

var r = [url removed, login to view]();

if( [url removed, login to view]() == 31 ) { //checks the column

var thisCell = [url removed, login to view](0,0);

var nextCell = [url removed, login to view](0, 10);

var indicatorCell = [url removed, login to view](0, 1);

if( [url removed, login to view]() != 'x' && [url removed, login to view]() != 'X' ) { // <> to x AND X

[url removed, login to view](new Date());

[url removed, login to view](0,102,255); //sets background to blue

}

}

}

Habilidades: Excel

Ver mais: PRICE IS NOT AN ISSUE. WE DON\ T MIND PAYING MORE FOR THE RIGHT DESIGN AND ANY OTHER ADDITIONAL THINGS YOU MAY OFFER., Google Sheet Script, update cell script google sheet, google sheet script print, write php script translate google, google maps windows mobile script, google maps api ready script buy, auto google youtube video search script, google adwords keyword tool script, google mashup real estate script clone, write mssql script, write perl script match name, write introduction script, write perl script send logs, sqlserver write file script, write spider script

Acerca do Empregador:
( 5 comentários ) orem, United States

ID do Projeto: #15180737

13 freelancers estão ofertando em média $29 para este trabalho

cgullapalli

Hi, I am good at google scripts. Looking forward to work on this project. Please provide me the sheet link to work on and test it and to get the scope of work. Relevant Skills and Experience Google scripts P Mais

$50 USD em 1 dia
(506 Comentários)
7.5
royalcalif

Hi Mr. Employer, Basically the Google sheets is running by Java script. So we have some knowledge in the JS. I have lot of experience in Google sheets and I can do this project in effective manner with 100% accuracy re Mais

$30 USD em 1 dia
(31 Comentários)
4.7
mohamedkaram93

Hi! I will be happy to help you with these two tasks. Regarding the first issue, when a new row is added, the formula will be automatically added to it using onEdit trigger. Regarding the second issue, the co Mais

$25 USD in 0 dias
(4 Comentários)
2.9
mhfsha

I can do this project perfectly if you need a perfect project please contact me

$15 USD in 2 dias
(2 Comentários)
2.4
renandurkar

Hi , I am an Automation Engineer with good experience in Selenium,QTP,Excel Macro . I am very confident to complete the task with in the timelines . Relevant Skills and Experience Excel Macro Selenium UFT Proposed Mi Mais

$25 USD em 1 dia
(1 Comentário)
0.8
ryanlaney

Hello potential client! I have over 6 years of experience working with Google Apps Script. Recent projects include invoice automation, email and communications streamlining, document editing, PDF generation, report Mais

$83 USD em 1 dia
(1 Comentário)
0.8
$25 USD in 2 dias
(0 Comentários)
0.0
$20 USD em 1 dia
(0 Comentários)
1.8
$25 USD em 1 dia
(0 Comentários)
0.0
mariamosama2013

About me: Graduated from statistic department in faculty of economic & politic science, Cairo University. Sub-specialized in social science computing Cum. Grade: Good Graduation project grade: Excellent. How can I Mais

$35 USD in 3 dias
(0 Comentários)
0.0
radooo

My bid is fair for this project. I am confident that you will not be disappointed by the work I do. Relevant Skills and Experience I have 5 years experience in programming and I made some personal projects in Excel Mais

$12 USD em 1 dia
(0 Comentários)
0.0
$20 USD em 1 dia
(0 Comentários)
0.0
techokeet

Good Day, I would like to assist you with this project. I have excellent experience and can deliver this project in time. You get the refund if you are not satisfied with the final result. Cheers, Tehsin Khan

$18 USD in 7 dias
(0 Comentários)
0.0