OK, yeah glide columns only stay in glide. Many people have had different results when using actions on submit. I honestly haven’t done actions on submit enough to know what does and doesn’t work. I think a lot of times it’s just timing and how fast the actions run. If a row isn’t finished writing then sometimes the On Submit actions don’t work right.
You could either do the IF in the google sheet instead, or maybe use a horizontal choice component that writes 0 or 1 to a column instead of using a checkbox or switch.
There’s a lot of other things you could do, like creating a custom form that temporarily writes values to user specific columns, then transfers them to your real columns. Then you could use and IF column to get your 0 or 1 and move that to the proper destination column. But doing it inside of an actual Form or Add screen can get tricky.