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:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ifnR-TeRkmk;context-place=forum/docs
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.

https://docs.google.com/spreadsheets/d/1UxefAXt6rZj-0IaWaPzlhSasnLV4zXk-qU2SqyqB0Jc/edit?usp=sharing

Hope this makes sense.

--------------------------------------------------------------------------------------------------------