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:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Yp6PU2gnepM;context-place=forum/docs

Creating a unique ID based on gender of respondent

 

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