Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

173
Views
Search entire google data sheet in search function in google sheets scripts

I'm building this database for my husband's job. I need the search function to search the entire data sheet for whatever is put in the search bar not just the first column.

function Search() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var formSht = ss.getSheetByName("Input Form");
  var recordsSht = ss.getSheetByName("Data Sheet");
  var sValue = formSht.getRange("C5:E5").getValue();
  var sData = recordsSht.getDataRange().getValues();

  for (var i = 0; i < sData.length; i++) {
    var row = sData[i];
    if (row[0] == sValue) {
      formSht.getRange("B9").setValue(row[0]);
      formSht.getRange("B11").setValue(row[1]);
      formSht.getRange("B13").setValue(row[2]);
      formSht.getRange("B15").setValue(row[3]);
      formSht.getRange("B17").setValue(row[4]);
      formSht.getRange("B19").setValue(row[5]);
      formSht.getRange("E9").setValue(row[6]);
      formSht.getRange("E11").setValue(row[7]);
      formSht.getRange("E13").setValue(row[8]);
      formSht.getRange("E15").setValue(row[9]);
      formSht.getRange("E17").setValue(row[10]);}
  }
}

Here is the link to my sheet and what I have gotten so far.

https://docs.google.com/spreadsheets/d/1ClQp_mT3d6CEFRrKu43g5ya6CK3M4H9EpPPjAZ1EUg8/edit?usp=sharing

about 4 years ago · Santiago Gelvez
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!