Copying rows

Vanessa White

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?

Mark Cronk

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

Mark Cronk

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

Vanessa White

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

Mark Cronk

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

Mark