Automatically copy specific fields from new rows in one sheet to another
We have an intake sheet / form and a separate project sheet.
Goal is to automatically copy specific fields from new rows in the Intake sheet (source) to a different Project sheet (destination) each time a new row is entered by users.
When a new row is entered, we want to copy (as a new row) specific fields from the Intake row to the Project sheet, only copying if the value in a specific column in the Intake sheet is set.
We have tried Zapier but can't figure out how to get it to copy the 'new' row, it wants a specific row in the rule (we are new to Zapier so this may be an easy solve but we sure can't fine it).
Thanks for any help!