I have a appscript code using "getlastrow" but it gets last row of the sheet instead of last row of data whereas my rows below data are completely empty and dont even have any hidden formulas.
How can i get last row with data instead of last row of sheet
