Hi,

I am wondering if there is a way to assign a numerical value to a text answer. Here is an example of what I am trying to do:

A survey is designed for inspectors to fill out. As they answer questions like,

"What is the distance to the nearest fire extinguisher?"

1: 10 ft.

2: 50 ft.

3: 100 ft.

I would like to assign a numerical value to those answers so 1 point for 10 ft., 5 points for 50 ft., and 10 points for 100 ft. At the end, I would like to be able to tally up the results of my survey with a total score for every answer to a question and be able to assign a risk value that the inspector can both see and submit in the form.

Is this possible?

THANKS!

Hi Robert,

Yes, you can use numeric values for the names of a list. For use in a formula, you will need to convert from string/text (which is how it will be stored) to integers using the int() function in the formula.