getRow google sheets code example

Example 1: cell get row google script

var cell = sheet1.getActiveCell();
var SelectRow = cell.getRow();

Example 2: get cell value from string google sheets

=CONCAT("value is ", C5)