If i understand your requirement correctly, this could be a workaround for you.
First, you create the action to add new row using this row value to another table. This is simple and basic, I assume you have this action in place.
Then create another action as Aleksi said, jump to another view within app. For the deep expression for this action, you place function something like
Then create another action to execute those two action as a group, and fire it in a way you want.
It will create new row to another table, then jump onto the form view for row which was exactly create by this action now.
There are other workaround available, but this could be easiest and simplest solution, as far as your data is sitting on the spreadsheet, rather than SQL where [_rowNumber] field is NOT counted on.