Can I have a form populate two different sheets?

Anne Reynolds

I want to have a project intake form that can direct projects to one of two different summary sheets depending on the type of project. Alternatively, I want the form to adjust the prefix for an auto-numbered project ID depending on the type of project. i.e. I am looking to implement one of the following two ideas.

Solution 1: "Research" projects are sent to one project intake sheet that auto-numbers the projects with the prefix RS, while "Infrastructure" projects are sent to a different project intake sheet that auto-numbers the projects with the prefect INF.

OR

Solution 2: The project ID prefix is dynamically changed depending the type of project. I don't particularly care if the numbers are sequential within a prefix grouping or across prefix groupings.

Anne Reynolds

Never mind. I figured out that I could set up a form to populate a dummy summary sheet. Then I set up an automated workflow to move rows from my dummy summary sheet over to the appropriate summary sheet and auto-number rows within the appropriate summary sheet. It's slightly clunky to have a dummy summary sheet sitting around, but it gets the job done for sure.

Genevieve P.

Hi @Anne Reynolds

Thanks for posting your solution!