Automation - While copying/Moving Source Sheet to Target Sheet, how to update columns in Target shee

Prasad Nimmagadda

I have following questions related to workflow automation

1. Is it possible, based on certain conditions in Sheet-A copy Sheet-A to Sheet-B and manipulate another column in Sheet-B (This Column is not in Sheet-A) through a function?
2. Based on certain conditions in Sheet-A, will it be possible to delete a row in Sheet-B?

Michelle Choate 2

1.) Yes it is possible to copy a row from one sheet to another, and then have additional columns in the destination sheet.

2.) The only way to delete rows is through Bridge. Instead you can try the MOVE A ROW automation. You can always create an archive sheet and use the MOVE A ROW automation to send it there, and then go in to the archive sheet on occasion and delete whatever you want.

Prasad Nimmagadda

Thanks, Michelle, for answering my questions.

Q1: I understand we can have additional columns in Target sheet. To clarify what exactly I need, I have to generate a unique sequence number for the row I am adding into Target Sheet. That Unique Sequence number is maintained in Target Sheet. I have already generated a unique sequence number in Source sheet, so it doesn't allow me to have another #auto number in target sheet. Unique Sequence number is required to identify duplicates in Target sheet.

Q2: I don't know what Bridge is. I am quite new to Smartsheet (using it last couple of months).