Report not summarizing where values are generated from a logic..

Not sure if this is doable or not but I am trying to create a report that will summarize by averaging the data fields where the number is being returned by an IF statement.

The problem is where my summary number should be in the report im just getting "NaN".

In the original sheet several responses have been collected where the response options are, Strongly Agree, Agree, Somewhat, Disagree, and Strongly Disagree. Next to each of the response columns I have another column that is turning those responses into a numerical value. "Strongly Agree" returns "5", "Agree" returns "4", etc.

even if I try to average at the bottom of the sheet it doesn't seem to recognize those values where the number is being generated by the statement.

Ultimately I'm trying to get to a dashboard where I will show a score which is the average of the response value for each question.

Any help would be greatly appreciated :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!