I am wondering if I can have a user change the value of one cell in my app.
I have a very large google sheet with around 20,000 rows on one tab, including 120 different stores, and on the main tab I use a query function to pull the data that I want.
I use a stores individual number to show the query what info I want to pull.
I can put this into appsheet perfectly, just would like the end user to be able to change the store number cell to change the data that the query pulls.
I have all the read only restrictions removed, but the store number field is grayed out.