Closed

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

}

}

}

Skills: Excel

See more: 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

About the Employer:
( 5 reviews ) orem, United States

Project ID: #15180737

11 freelancers are bidding on average $31 for this job

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 More

$50 USD in 1 day
(513 Reviews)
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 More

$30 USD in 1 day
(31 Reviews)
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 More

$25 USD in 0 days
(4 Reviews)
2.9
mhfsha

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

$15 USD in 2 days
(2 Reviews)
2.4
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 More

$83 USD in 1 day
(1 Review)
0.8
$25 USD in 2 days
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
1.8
$25 USD in 1 day
(0 Reviews)
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 More

$35 USD in 3 days
(0 Reviews)
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 More

$12 USD in 1 day
(0 Reviews)
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 days
(0 Reviews)
0.0