One Google Docs user had asked a question on the Forum regarding auto-sorting a Task List when there is change in status of a Task. I thought that as a user I may also face this problem sometimes.
I created a Spreadsheet with List of Tasks in Column A and the Status of the Task in Column B. Initially I sorted the Data by Column B but when I changed the status of any Task it was not getting sorted automatically.
Then I read the description of SORT command and wrote the following command in cell C2:
=SORT(A2:B21, 2, TRUE)
This created a sorted list in Column C and D. Now If I change the status of any Task in Column B the sorted list got changed automatically.
I have shared this Template on Google Templates Gallery and you can use it too.
04 October 2009
01 October 2009
Long Survey questionnaires on Google Forms.
Google released a new feature to add page break to create multiple pages on Forms. Now in a long survey questionnaire the respondent could be sent to a particular page depending upon Yes/No or other options in multiple choice question.
Earlier when we created long survey questionnaires it was made only on single page and the respondent was getting nervous looking at it. Moreover, logic branching was not possible depending upon the answers. With this feature one can show limited number of questions on first page and depending upon the answer to a question (which may be placed anywhere on the page) the respondent is sent to a page which is relevant to his/her response. On next page also same type of question may be asked.
Although the respondent is not completing all the pages it is possible to write mandatory questions on any and all pages because the questions are mandatory only for the respondent for whom the page opens depending upon his previous response.
Suppose the respondent has made the earlier choice by mistake and realises this on subsequent page he/she can press the back button to go to the previous pages and change the response.
You can read about this on Google Docs Blog. The instructions to use the new feature are here.
Earlier when we created long survey questionnaires it was made only on single page and the respondent was getting nervous looking at it. Moreover, logic branching was not possible depending upon the answers. With this feature one can show limited number of questions on first page and depending upon the answer to a question (which may be placed anywhere on the page) the respondent is sent to a page which is relevant to his/her response. On next page also same type of question may be asked.
Although the respondent is not completing all the pages it is possible to write mandatory questions on any and all pages because the questions are mandatory only for the respondent for whom the page opens depending upon his previous response.
Suppose the respondent has made the earlier choice by mistake and realises this on subsequent page he/she can press the back button to go to the previous pages and change the response.
You can read about this on Google Docs Blog. The instructions to use the new feature are here.
Subscribe to:
Posts (Atom)