send a value to a cell based on a chosen radio button

Hello All,

I am trying to get a assessment questionnaire to populate scores to their appropriate place once a answer is made. I am attaching a dummy file (for simplification and file size) that has 4 questions with 3 button choices each and a place for the scores to go. I would like to have a person chose a button answer and if they chose the "never" a "1" populates to the G cell for the question. If "sometimes" then a "2" populates and if an "often" a "3" populates. I used a "form control" button for the example but am open to what I need. I hope this makes sense. Thanks in advanced for any help.