What a few of us are pointing out is that you can perform this functionality directly within glide. It will be much easier and much quicker as I point out in this other post from earlier today.
Trying to use formulas in google sheets adds a lot of unnecessary complication unless you absolutely need those formula driven values to be in the google sheet for uses outside of the app. From the looks of what you are trying to do, your formulas appear to be very basic, so would be very easy to accomplish with built in glide functionality. It’s definitely worth the simplicity and the instant speed results compared to waiting for the google sheet to update and sync back to glide.
Arrayformulas in the google sheet are fine, but it will create lag in your app and require you to make sure that you delete all empty rows in the sheet for it to work properly.