Saturday, June 10, 2017

yogi_Based On Form Input Make A Computed Column For Gender Based ID For male and Female Students

Google Spreadsheet   Post  #2180
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-10-2017
question by Ovation Theatre:
Hello! I am a high school theatre teacher looking to utilize Google Forms for our musical auditions. I was wondering if it is possible to create a unique ID based on the gender of the respondent. For example, I may have three male students sign up, and they are assigned M001, M002, and M003 based on marking "Male" as their gender on their forms. Similarly, when female students sign up, they are assigned, F001, F002, etc.

Is this possible? This would save me an enormous amount of time if we already assigned audition numbers prior to the audition