Google Sheet Script - Find Value In Col And Delete Row

So I'm working on a script to search my Google Sheet for a value and then delete the row, so far I have this: function sort() { var sheet = SpreadsheetApp.getActiveSheet(); v

Solution 1:

Use this instead: if (row[0].indexOf('test') > -1)

The problem with your solution was that it only checked if the row was exactly equal to test, this instead checks if the row contains test at all.