tag:blogger.com,1999:blog-8807805591547673516.post1102771444252847759..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Set Up Spreadsheet So That New Entries From A Form Appear On The TopYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8807805591547673516.post-61636616304144431472020-04-19T11:01:35.020-07:002020-04-19T11:01:35.020-07:00I have three teachers using the same Google Form. ...I have three teachers using the same Google Form. I would like to set a sort filter so each time a student fill out a Google Form, it is automatically sorted by the Teacher's name. I know how to sort the sheet, but each new submission ends up at the end of the sheet and not sorted. Can you please help with this? I have spent 3 hours watching videos and still don't know how to do this. Thank you so much for your help!Anonymoushttps://www.blogger.com/profile/06026058622628331037noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-30208714517862473052020-01-23T06:37:57.873-08:002020-01-23T06:37:57.873-08:00i want to get auto sort filter 1 minutes once i want to get auto sort filter 1 minutes once Anonymoushttps://www.blogger.com/profile/18207200587752719146noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-50900558380752136492013-06-14T10:45:33.200-07:002013-06-14T10:45:33.200-07:00I have the same issue with t, the date is on my wo...I have the same issue with t, the date is on my worksheet is on column B. where do I need to put the formula in order for the sort function to work? Thanks. VhielVhielhttps://www.blogger.com/profile/05119137429381979136noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-70772888766574873482012-10-11T17:25:30.000-07:002012-10-11T17:25:30.000-07:00Hi Scott Swanson:
It is best to leave the so call...Hi Scott Swanson:<br /><br />It is best to leave the so called Form Responses sheet (in this solution named ResponseTable) alone ... this is a sort of database and should not be tampered with.<br /><br />The needed reports should always be generated separate from the database ... because many reports may need to be generated from the same database.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-3499472569797494742012-10-11T11:40:13.683-07:002012-10-11T11:40:13.683-07:00Thanks for this Yogi. Is there a way to pull the ...Thanks for this Yogi. Is there a way to pull the data in and use the Sort function all in one sheet? Rather than creating a sister sheet to perform the sort function on?Scott Swansonhttps://www.blogger.com/profile/06158270285620948568noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-65485776942270474572012-08-28T10:08:28.618-07:002012-08-28T10:08:28.618-07:00Hi t:
for a solution to your problem ...
I have a...Hi t:<br /><br />for a solution to your problem ...<br />I have added the following:<br />user_t_Sheet_A<br />user_t_Sheet_A_sorted<br />in this blog post.<br /><br />I hope this helps.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com<br /><br /><br />Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-11295150475946872202012-08-28T01:31:42.265-07:002012-08-28T01:31:42.265-07:00Hi yogi,
thanks for the quick answer.
here is a ...Hi yogi,<br /><br />thanks for the quick answer.<br /><br />here is a portion of the spreadsheet... <br /><br />https://docs.google.com/spreadsheet/ccc?key=0AhTuOyyixW2wdGF6eTlQYV9ndGdVQmtGWkZDblFUbWcthttps://www.blogger.com/profile/05677070996890708130noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-50287250034009967682012-08-27T15:09:34.598-07:002012-08-27T15:09:34.598-07:00Hi t:
With the Timestamp in column B, it should n...Hi t:<br /><br />With the Timestamp in column B, it should not be difficult to modify the formula ... can you share your spreadsheet with me and show me what formula you used so I can see where the problem is ... and then let us take it from there.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com<br /><br /><br />Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-15244437195019375892012-08-26T14:08:35.774-07:002012-08-26T14:08:35.774-07:00Hi Yogi... Your formula works when the timestamp i...Hi Yogi... Your formula works when the timestamp is in column A but I could not modify the formula to make it work on sheets where timestamp is on column B. Is there a way to do it in such sheets?thttps://www.blogger.com/profile/05677070996890708130noreply@blogger.com