Q&A Session for Doing more with Spreadsheets in Google Docs
March 22, 2011 4:30PM/7:30PM ET
________________________________________________________________
Q: Can you allow a user to fill out a form only once?
A: At this time you cannot. However, with Google Apps for Education, you can specify to collect the username and be able to see how many times a user fills out the form and choose which timestamp to use.
________________________________________________________________
Q: How to insert images into forms?
A: Unfortunately this is not possible at this time. One workaround is to embed the form into a Google Site and include images on the page.
________________________________________________________________
Q: I am desparate to be able to merge cells vertically. I recognize that it can limit the database functions, but it prevents my collaborators from using my G Spreadsheets.
A: The feature is on the list of todos and hopefully will be implemented soon.
________________________________________________________________
Q: I love the gauge and have used it before. Any chance we'll be able to customise the type of gauge more in future?
A: Probably not. The only customization offered is the color ranges on the gauge.
________________________________________________________________
Q: How would you do the nested if statements for “tiered” grading?
A: =IF(C19="Good",100,IF(C19="Great",200,0) -- at the point when you would have the “0” for an incorrect answer, you use another If statement. This way the spreadsheet reads it as “If the answer is Good, give it 100, if not... if it’s Great, give it 200, if not, 0. You can continue to add if statements where the 0 or “wrong answer” would be to add different values for answers.
________________________________________________________________
Q: All chart types can be published to a webpage, right?
A: Yes, with the exception of annotated timeline and motion chart