"Values Scores" doesn't seem to work as I expected ...
Hi all, Trying to find a way to automate/optimize the analysis of survey results and hoped I could use the "Value Scores" Column Property to assign numerical values (scores) to the responses provided, e.g. Very good => 5, Good => 4, Average => 3, etc. With that I can calculate averages, ranges, create charts, etc.Data comes from MS Forms through an Excel download. We are talking about many surveys...