Bob's solution would work well for this. Yes google spreadsheet can do this
I would tweak the solution slightly
Check off Collect usernames in forms
That way the data would be a constant
Sent from my iPhone
Apologies for brevity and autocorrect typos - I really do care :)
On Sep 27, 2013, at 4:00 PM, Bob Wickberg <[log in to unmask]> wrote:
> In excel i'd use the countif function to do this. If there was a list of
> all the teachers in column A, and a list of some of them in column C, then
> =countif(A1,C:C) would return a 1 if the teacher in A1 was in the list in
> column C, and a 0 if he's not. So put that in B1, then copy to all cells
> in column B that have names in column A. Of course, you have to spell
> the teacher's name exactly the same in both lists...
> If you want to see yes/no rather than one/zero, or anything else, you just
> wrap the if function around this.
> I don't know if you can do this in Google spreadsheets.
> Bob Wickberg
> Technology Coordinator
> Brattleboro Union High School District # 6
> School Information Technology Discussion <[log in to unmask]> writes:
>> I'm looking for a solution to a Google Forms issue.
>> The principal has a form that collects data regarding teachers'
>> attendance at extra-curricular events. (The teachers fill it out.) My
>> goal is to find a way that allows the principal to see who has not yet
>> filled the form out more quickly than searching the spreadsheet. Is there
>> a script that compares the collected data to a list of the individuals
>> who need to fill the form out? Is there another way that we could get
>> this result?
>> Matt Allen
>> Innovation Specialist
>> St. Albans City School
>> St. Albans, VT 05478
>> Twitter: @mrallen5
>> Blog: [ http://mrallenslearning.blogspot.com
>> (802) 393-8081
>> "Everybody is a genius. But if you judge a fish by its ability to climb
>> a tree, it will live its whole life believing that it is stupid." Albert
>> CONFIDENTIALITY NOTICE: The information contained in this transmission Is
>> privileged and confidential information intended only for the use of the
>> individual or entity named above. If the reader of this message is not
>> the intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this communication is strictly prohibited. If
>> you have received this transmission in error, do not read it. Please
>> immediately reply to the sender that you received this communication in
>> error and then delete it. Thank you.