I have a table with a numeric pain scale (0-10) in Column A paired with basic descriptors in Column B.
I would like the user to be able to SEE the numeric + basic descriptions when choosing a pain level in the form drop down menu…but NOT record the basic (text) description. How can I show the below, but only record the numeric value chosen? Thanks!
Example of desired drop down view: 0 No Pain 1 Very Mild 2 Discomforting 3 Tolerable 4 Distressing 5 Very Distressing 6 Intense Pain 7 Very Intense Pain 8 Horrible Pain 9 Excruciating 10 Unimaginable Pain