asign a number to a text string
it has to be very easy but I have not found the way to do it.
What I'm tryig to do is some list of companies and for their services I want
to use Yes for 1, No for 0, Sometimes for 0.5 and Maybe for 0.25.
just asigning these numbers to the text is what I want, so that it is easely
readable and editable for everyone and it still can make some addition of it
in the end.
Example:
Kwik e-mart Fruits - Vegetables - Meat - Fish - Fresh Total
score
Yes Yes Sometimes No Maybe
2.75
To add this data, I used the validation function so that there is a dropdown
menu for each criteria (Yes, No, Sometimes, Maybe)
|