I have a Google Sheet with two sheets, one that holds the backend data and one that is user-facing.
Here’s Sheet1, which is hidden from normal users and has all its data entered manually:
Then Sheet2 auto populates from Sheet1 using a query, and asks the user for some input on each entry:
The problem is when data is added/removed/moved in Sheet1, the order of the query changes but the user-entered data doesn’t move accordingly. Is there a way to get the data entered in Sheet2 to update with the query from Sheet1 so they stay matched?