If I add an auto increment row # to my table, how will that help me find the row that contains the record I want to update? In Tadabase, I may want to update the row with record id 123, for example. I need to find a row that has a specific value in it’s first column (“Record ID”) and update all the cells in this row.
The row # Google Sheets is asking for is constant and uses A1 notation. What happens if I sort my data in Google Sheets? Now, all my data could have the row placement changed. Row 1 in Google Sheets and Row 1 Auto Increment ID starts out aligned. If I sort it, now auto increment row 25 may now be in row 1 place. In Integromat, their Google sheets function has a way to look up a row # using a filter.
Can we have a filtered row lookup and filter row update function?