Enter New Data in Empty Row

[tvinci]

Hi AppSheet,

So I managed to enter a formula into my Google Sheets backend that transposes client names the way I want it to. But when a user populates a new route into the backend, I want that new route to be entered into a new row, not to overlap with populated rows like it’s doing here:

So ideally, in this example, I would like the “testRoute2” to be populated AFTER A. Health Care Center, in row 6, because row 6 is empty.

Thanks.