Hey @lamartine.lopes thank you for your reply !
i still trying to find solution, is there any way that i can fetch the value of the row ?
Hello @jocen , thank you for your solution, i tried using your solution, but it only works if the next column is a number, it doesn't work if the next column is plain text, any idea how to make it work?
On your GSheet, set column A as primary ID for that specific table.
Set A2 as 1 or whatever number you want to start at
A3 would be =if(B3,A2+1,) then drag that thing down.