Copying rows

I have an intake form that creates a new row in smartsheet for each submission. The intake form is used for our entire department, but when a certain box is selected, I have set up a workflow to copy the row into a team work effort sheet. I don't need all of the columns from the intake sheet on the work effort sheet, so I hid some of them. Everytime a row is copied over, new columns are created in the work effort sheet since some of those rows are hidden. Does anyone have a work around for this?

Best Answer

  • Mark Cronk
    Mark Cronk โœญโœญโœญโœญโœญโœญ
    Answer โœ“

    Hi Vanessa,

    Interesting problem. Instead of copying rows to a new sheet, can you have the team work effort staff work from a report? You can generate a report displaying only the columns you need and only rows withthe certain box selected.

    I didn't realize that hiding a column caused new columns to be created when a row is moved in. I would have expected it to populate the hidden rows.

    Any help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk โœญโœญโœญโœญโœญโœญ
    Answer โœ“

    Hi Vanessa,

    Interesting problem. Instead of copying rows to a new sheet, can you have the team work effort staff work from a report? You can generate a report displaying only the columns you need and only rows withthe certain box selected.

    I didn't realize that hiding a column caused new columns to be created when a row is moved in. I would have expected it to populate the hidden rows.

    Any help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Vanessa White
    Vanessa White โœญโœญ

    Great idea Mark! Thank you so much. I will try that and see how it works for the team!

  • Mark Cronk
    Mark Cronk โœญโœญโœญโœญโœญโœญ

    Good luck. Happy to help. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.