If you are using a Google Sheet as the home to your Role column, you can point the Role column to another column that you update. So, if your Role column is A with a Role value in A2, you can use an equation like ‘=B2’. You can add complexity to this to assign roles other than the one you are assigned, i.e., your equation can use more than just column B to make it do what you want.
If you are using a Glide table, then you need to use a service like Zapier or Make to assign this value to the correct cell. In fact, this is a perfect entry into using Glide with either of these services to send a value from Glide out, and then that value (or another) back to Glide to the correct table/row/column. I’ve learned a lot from the youtube videos made by @Darren_Alderman and @Robert_Petitto, you should check them out if you haven’t already.
Also, anyone working for Glide, if this Role setting ability is a bug, please don’t fix it! 