Tuesday, April 26, 2016

yogi_Assign Numeric Value To Text Attributes And Sum Up Row By Row Score From Different Sheets

Google Spreadsheet   Post  #2062
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-26-2016
question by: Tanya Peters:
Data Validation - Assign Value for text
I am needing to assign a value to some text that we are using to score a person from 1 to 3 for our application process. Can anyone help on how this should be done as we have 3 sheets we are compiling into a main dashboard to pick our top candidates.

I also would like to have the candidates on the main page and have them compile into each of the 3 sheets so we are always the same across the board.

Here is a link to the spreadsheet we are working on.

Hope this makes sense.