We would advise you to bring as many thing as possible to Glide to enhance your app’s performance. If you do some calculation inside the Sheet opposed to Glide, there will be a delay time for that to sync back.
However if you absolutely need to have the data in the Sheet for other purposes, here’s my tutorial for using arrayformula to apply formulas to all rows.