I am trying to hide rows when a cell says "Approved", this is what i have so far but it appears to be hiding all data even when "B:B" is "Pending"
function ConditionalHideRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var condition = sheet.getRange("B:B").getValue();
if (condition = "Approved") {
sheet.hideRows(1,25)
}
}