AnsweredAssumed Answered

Yes, no, Maybe fields

Question asked by gilbthomas on Feb 1, 2016
Latest reply on Feb 3, 2016 by gilbthomas

I am creating a file to use during hiring for a business. I would like to create a form with two fields, one for each of the hiring managers in which I could select yes, no, maybe for each applicant and a third field would indicate whether the applicant should be interviewed (we both said yes, or one yes and one maybe), the applicant should not be interviewed (we both said no, or one no and one maybe) and we should discuss the application (two maybes, or one yes and one no). Thus far, I have built a form that allows for most of this, but it is numerical. I have to input 0,1 or 2 for no, maybe and yes. I will be importing the other hiring manager's decisions from excel and they will be in the format of no, maybe, yes. Does anyone know if there a way to convert no, yes, maybe to 0,1,2 while importing? Or could someone tell me how to assign values or build a calculation that will do what I want using text?