When one of our stakeholders has a project request, they fill out a form that, depending on the type of project they select, will give them one of three sets of questions to fill out. Based on the question sets that they fill out, it will be assigned to one of three teams to work on. I would like to have the main form sheet then auto populate a new row in the appropriate team's project tracker sheet with only the columns that correlate.
I tried Move Row but then it added all the columns. Data Shuttle would be my next guess but it only works for bringing info into/out of SmartSheet, not within. And with Data Mesh, I can't find a way to filter which responses go where (i.e. If Column A says "Branding" move data to the Branding Projects sheet).
Is this possible or does it need to be manually done?
