google sheets get current row?

Google Sheets – Get Last Non-Empty Cell in Row or Column

The syntax is: Row( reference ) but if the reference parameter is omitted, it assumes the cell in which the Row function was entered. This can be used to refer to cells using indirect , for example =indirect(“C” & row()) refers to column C in the current row.

Google Sheets – Conditional Formatting Entire Rows | Text or Dates

Leave a Comment