I have a shared Google Spreadsheet where sales and engineering use different columns for reference. I would like to automate some functionality but as a very new Google Spreadsheet user, I don't know how to code this just yet.

Sales has a form with the following columns from this spreadsheet:
Project ID
Date
Customer
Primary Product
AE
Description

When they fill out the form to request a new Project ID, it fills in the remaining columns above and then engineering goes in to fill in the rest (not identified here). I would like to generate an auto-email to sales when they fill out this form so that they get an email back with the information they filled-out (for verification) as well as a new Project ID number which should be auto-generated with 'SIDPRJ' at the very beginning so that they look like SIDPRJ0001 and increase by 1 for each one.

Any advice, would be seriously appreciated.

Thanks.