Hi. I really wish someone could help me. I have Google Sheet 1 which contains columns for Email and RowID (which value I assigned using the number of seconds since 1970). I also have Google Sheet 2 which contains column SubRowID. Given the Email used in logging in, I need to get the corresponding RowID in Google Sheet 1 and paste the RowID, with a suffix “-1”, in Google Sheet 2 under the column SubRowID. I did it once by chance but I lost it. Now, I cannot figure it out no matter what. Please be kind to help me. I will really appreciate it. Thank you.
Hi @investdevice9x14bf
When you create a new row you can save the row id into a variable. Then use the variable to save the id on the column SubRowID.