Find Jobs
Hire Freelancers

Resolve issues with functions and programming in Google Sheets

$10 USD

Dibatalkan
Dibuat lebih dari 5 tahun yang lalu

$10 USD

Dibayar ketika dikirim
I need someone that can help my programmer resolve any issues he is having with a Google app and spreadsheet. I will pay $10 after Chuck tells me that he has gotten all that he needs from you. INITIAL PROBLEM: We have a google script running in conjunction with a google sheet, and we are having trouble with this function: function inCol( comparestr, searchcol, IDofSpreadsheet, NameOfTheSheet ){ var sheet =[login to view URL](IDofSpreadsheet).getSheetByName(NameOfTheSheet); var data = [login to view URL]().getValues(); [login to view URL]('incol( ' + comparestr + ')'); for(var i = 2; i < [login to view URL]; i++){ if(data[i][searchcol] == comparestr){ //[1] because column B return i; } } return -1; // no match found } It's always returning -1 because the comparestr is getting interpreted as a number instead of a string. How can I force a string comparison with this argument?
ID Proyek: 18390212

Tentang proyek

1 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
1 freelancer menawar dengan rata-rata $15 USD untuk pekerjaan ini
Avatar Pengguna
Hey there. I can fix your problem, can you send me all script, including the part where your developer call the "inCol" function?
$15 USD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
Waco, United States
4,2
89
Memverifikasi Metode pembayaran
Anggota sejak Feb 13, 2009

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.