Hi, i have a quite complex set up which i now want to added.
I have an intake sheet where i collect all kinds of different information. The intake sheets holds projects from 0001 to 9999. I then have a metadata sheet which is linked to the intake sheet so that i can just put in the project number in the metadata sheet so all information gets transferred in the metadata sheet. I then have templates for the projects and the sheet summery of the projects is linked to the metadata sheet. So i can create a lot of different projects just by putting in a different project number in the metadata sheet so it picks the right project form the intake sheet.
Now i also have attachments in all the the different project rows in the intake sheet. And i want to move the specific attachments from specific projects to the project sheet.
I'm unsure of how to make sure to get the right attachment to the right project by using automations. I thought about using copy row. But i would need an if-formula to make sure it picks the right projects number and so on.
Is this somehow possible?