I have a Google Docs Spreadsheet that I use for workflow. I also use a form to collect bids and their category for each job. The bid information from the forms is collected in one of the sheets (Bid Form Submissions). I have another sheet (Bid Intake) that consists of various categories and cells for 3 bids in each category. I would like a script that will collect the form information (from Bid Forms Submission sheet) and input it in the correct category on the Bid Intake Sheet. It would need to determine whether or not a bid has already been entered in the 1st bid location for that particular category. If so, it would need to be placed in the 2nd location. The same would follow if there were already bids in the first 2 categories. It would also need to be able to run each day to look for new bids that have been submitted without overwriting the older bids.