Form Entry Mapping

Options

Is it possible to have form entries map to a specific sheet and field?

I've created a workflow that copies form data from it's collection sheet to a different sheet called "January". My question is... Is there a way to designate what fields this data gets copied to vs. having it add a line with this information? Can I write a formula or something that would check data in row A and plce the form data in that row in specific cells?


Thanks Ron

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Ron Erdeljac

    Hope you are fine, as i understand from your question that you collecting the data with Form then you have workflow copy the entire row to another sheet but you want just to copy specific cells only.

    my suggestion to do that you can add an autonumbering column in the collecting sheet and in the January sheet you can add a column format formula using ( Vlookup ) to get only the cells you want from the row by using the row ID as a reference.

    only you need to copy the row ID column from the original sheet and paste it into the "January" sheet

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Ron Erdeljac
    Ron Erdeljac ✭✭✭✭
    Options

    Thank you for the response. I did figure out the Vlookup action to place the data in the January sheet in the correct cells. But now that I've done this, I have to add a monthly identifier. Meaning if the form designates February vs. January I need the data to be placed in the correct monthly sheet.

    I have a year and month column in the form which feeds the collection sheet. Is there away to auto check the month column and have the currently used Vlookup to place the collection sheet data into the appropriate month's sheet?


    thank you!

  • Ron Erdeljac
    Ron Erdeljac ✭✭✭✭
    Options

    I suppose I should have explained that the monthly sheets have predetermined data in them that cannot be over written. This is my reasoning for wanting to place the collection sheet data into specific cells.

    That said, I had to disable the workflow that was copying the collection sheet row to the monthly sheet as I do not want to have the collection row data added to the bottom of my monthly template.

    As mentioned, the Vlookup referencing the collection sheet works great. Now I need to ensure the data is placed into the appropriate monthly sheet.


    Thank you for your assistance