Hi,
I am trying to figure out why I keep getting this error message:
The Impact Value is the average of the Confidentiality, Integrity and Availability column. (Confidentiality+Integrity+Availability)/3
The Risk Value should be multiplying the Impact Value with the Likelihood Value. But I am getting an error message with this basic formula {Impact Value}*{Likelihood Value}
Please help.
Best answer by Rupert_Hoffsch1
Hi and welcome to the Airtable community :slightly_smiling_face:
The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).
Cheers,
Rupert
+21Hi and welcome to the Airtable community :slightly_smiling_face:
The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).
Cheers,
Rupert
Hi and welcome to the Airtable community :slightly_smiling_face:
The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).
Cheers,
Rupert
Amazing! This worked. Thank you so much!
+5Hi and welcome to the Airtable community :slightly_smiling_face:
The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).
Cheers,
Rupert
That helped me, too. I’m trying to average scores from a survey, but my survey has 19 questions. Worse yet, my fields are more like “My position is a good fit for someone with my knowledge, skills, and personality.”
Do I need to apply the VALUE function to each field (question)? In the example above, would I need to apply VALUE({Confidentiality}) and VALUE({Integrity}) and VALUE ({Availability}) and so forth or is there a better way? Is there a Value version of Single Select?
I found the number field type, which might do the trick. Is there a way to limit number responses to within an acceptable range?
+29That helped me, too. I’m trying to average scores from a survey, but my survey has 19 questions. Worse yet, my fields are more like “My position is a good fit for someone with my knowledge, skills, and personality.”
Do I need to apply the VALUE function to each field (question)? In the example above, would I need to apply VALUE({Confidentiality}) and VALUE({Integrity}) and VALUE ({Availability}) and so forth or is there a better way? Is there a Value version of Single Select?
I found the number field type, which might do the trick. Is there a way to limit number responses to within an acceptable range?
There is not a way to limit a number field to a range in a form. Is your maximum number is 10 or less, you could use a rating field, which can have a maximum value of 10 or less.
If you want to keep your answer fields as single select values with text values, you can use a SWITCH formula to convert the text to a number.
SWITCH( {singe select field name},
"High", 5,
"Medium", 3,
"Low", 1
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.