Set Up User Roles

Setting up user roles in Google Sheets

Change your column into a dropdown.

Go to Data -> Data Validation -> List of Items -> Enter in the roles you want.

Once this is set up run an update and go to the column for that sheet in your app.

Select Dropdown and add in the roles.

Run an update and in Setup Home -> Roles you can now select the column and configure the roles.​