Google Spreadsheet Post #2062
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.
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/docsData 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.
--------------------------------------------------------------------------------------------------------