Hi,
Since my team has selected the pain scale symbols as their preferred method of scoring work, here I am struggling to make the following formula work.
=IF([Value to User]@row = "No Pain", 4, IF([Value to User]@row = "Mild", 3, IF([Value to User]@row = "Moderate", 2, IF([Value to User]@row = "Very Severe", 1, IF([Value to User]@row = "Extreme", 0)))))
The team can still select the appropriate smiley (or not so smiley) face and view it in the cell, but I would like to be converting each to a number on the sheet summary and my metrics sheet so that I can get a collective average to report out on.
At the row level, I will be averaging across all four (4) criteria - This is what I have tried there
=AVG(IF([Value to User]@row = "No Pain", 4, IF([Value to User]@row = "Mild", 3, IF([Value to User]@row = "Moderate", 2, IF([Value to User]@row = "Very Severe", 1, IF([Value to User]@row = "Extreme", 0))))) + =IF([Criteria2]@row = "No Pain", 4, IF([Criteria2]@row = "Mild", 3, IF([Criteria2]@row = "Moderate", 2, ….)))))+ =IF([Criteria 3]@row = "No Pain", 4,…..))))) + =IF([Criteria 4]@row = "No Pain", 4,…..))))))
I want to find an average for each column.
I am getting the response "UNPARSEABLE"