Đã Đóng

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

}

}

}

Kỹ năng: Excel

Xem thêm: 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

Về Bên Thuê:
( 5 nhận xét ) orem, United States

Mã Dự Án: #15180737

11 freelancer đang chào giá trung bình $31 cho công việc này

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 Thêm

$50 USD trong 1 ngày
(513 Đánh Giá)
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 Thêm

$30 USD trong 1 ngày
(31 Đánh Giá)
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 Thêm

$25 USD trong 0 ngày
(4 Đánh Giá)
2.9
mhfsha

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

$15 USD trong 2 ngày
(2 Đánh Giá)
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 Thêm

$83 USD trong 1 ngày
(1 Đánh Giá)
0.8
$25 USD trong 2 ngày
(0 Đánh Giá)
0.0
$20 USD trong 1 ngày
(0 Đánh Giá)
1.8
$25 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$35 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$12 USD trong 1 ngày
(0 Đánh Giá)
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 trong 7 ngày
(0 Đánh Giá)
0.0