Numerical Values (Points) for Dropdown Fields and totaling the Numerical Values
I am working on a sheet where I have 6 fields that require the user to select a value. Each field's value will have a numerical (points) equivalent. I have created the 6 dropdown fields and was successfully able to build a "helper" column next to each, using an IF statement to populate the Helper column with a numerical value based on the user's selection. However, when I try to total all the "Helper" columns up, I'm getting issues with the decimal points and or incorrect totals. In my "IF" statements, should the numerical values be in "quotes"? Should I include all decimal points? The numerical values include, 0, .25, .5, and 1.
Also, in one of my columns, the user can select multiple values and each value has a numerical equivalent, how can I "add" the multiple values from that cell and have it totaled to be added to the Grand Total?
In the screenshot below, this is one of my data columns, that has 4 values and numerical equivalents. Guess I should start with is the right format for that?
Thanks in advance!
Client Meeting Required is the data field and CMR Helper is where the formula is.
Help Article Resources
Check out the Formula Handbook template!