Move Rows Automation

aalang103696

I keep coming up with an error when I am setting up the Workflow automation to move rows. See attached:

 

BrianBosché

Hello, I'm a product manager at Smartsheet. Is the new Proofing feature enabled on your sheet? Right now you are not able to use Automated Move Row if Proofing is enabled, so you will need to disable Proofing to Automate Move Row. We are allowing Automated Move Row on a sheet with Proofing enabled soon!

Mike Wilday

Have you tried creating a new sheet to move the rows to? And then switching it back? It sounds like there is an issue with that sheet. 

aalang103696

I have tried a new sheet and then I have also tried to 'Save as New' from the sheet I want to move the rows from so that all the columns are the same. Both give me the same error. 

BrianBosché

Hello, I'm a product manager at Smartsheet. Is the new Proofing feature enabled on your sheet? Right now you are not able to use Automated Move Row if Proofing is enabled, so you will need to disable Proofing to Automate Move Row. We are allowing Automated Move Row on a sheet with Proofing enabled soon!

aalang103696

THAT WAS IT!! I disabled it and it is now working!

 

Thank you so much! 

Mike Wilday

I'm glad you got it working. 

BrianBosché

Great! Glad you got it working. This is only a temporary restriction. You will be able to Move Row (manually or through automation) with proofs by the end of the month.

Lynette.Smith

HI Brian- When will this restriction be turned off? I am running into this restriction today. In addition to this issue, the sheet I need to turnoff proofing isn't showing the slide switch to turn it off or on but the function is active. I plan to put a ticket into support for this.

BrianBosché

Hi Lynn, yes we will be lifting this restriction soon! Stay tuned.

Maricarmen Vargas

@BrianBosché

Great! Glad you got it working. This is only a temporary restriction. You will be able to Move Row (manually or through automation) with proofs by the end of the month.

Hi Lynn, yes we will be lifting this restriction soon! Stay tuned.

Can't wait for this!🙏 🎉

BrianBosché

@Maricarmen it works now! Have you tried it out yet? I would love to get your feedback if it is working well for you.

Regina Botell

Hi All,

I have created a workflow to move rows once a condition is met. I also made sure that the source sheet was disabled for proofing. The rows are not moving to the destination sheet.

Any help would be greatly appreciated :)

Genevieve P.

Hi @Regina Botell

How is the Move Row workflow triggered?

"Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas. This includes Request an approval, Move rows, Copy rows, Lock rows, and Unlock rows."

See this article on trigger blocks for more information: https://help.smartsheet.com/articles/2479236

Regina Botell

Hi @Genevieve P

I made sure that there were no cell links associated with the sheet. I am still having issues with moving rows over to another sheet.

Genevieve P.

Hi @Regina Botell

Could you post pictures of your current set up? (But block out any sensitive data).

A picture of the workflow opened up (how it's triggered, any conditions, etc), and then also a picture of the current sheet open in Grid View.