I hate the fact that my answer wont help you achieve what you are trying but something that I’m almost always remembering to other users is that you worksheet is a database for AppSheet, nothing else. So you shouldn’t touch it at all. The usecase where you need to use the worksheet directly defeds the purpose of an app and most of the strengths of it get lost
No the solution is in APPSHEET not in GOOGLESHEET
TAKE A LOOK:
Even I didn’t understand what he say but I followed the video and that’s work https://youtu.be/lH1fAB3KT0I