It might be that the reference fields for user group cannot be formula type fields. I remember previously trying to set the user email address to a formula field and running into some problems.
Perhaps a solution would be to use an automation to write the data you want to a text/option field that Softr can accept for syncing.
it would be good to know what you find. Hope it all works out with ease.