ah, I see.
My guess would be that you might have a chicken and egg situation. That is, the Set Column Values happens before the values are calculated. This might work better with a Custom Form.
Curious about why you need these values in the Google Sheet? Are they used outside your app?