Automate Copy of One Cell Only - not the row
I'm trying to automate an element of work that I currently do manually. I have two sheets, Project Intake and Pipeline. When a new entry is added to the Project Intake sheet I want it to automatically copy the Project ID cell only to the Pipeline sheet. I then have a datamesh set up to run and copy over only the data I want for that project into the Pipeline sheet.
Can anyone tell me how to do this, or provide an alternative way to automate this please?