Having trouble with the move function

JayPedde

I've added a column with a simple formula to check a box when a column clears itself of an error

=IF(ISERROR([Written number Ref]7), 0, 1) - woks fine no problem, the box gets checked when it is supposed to

Once the box is checked I want to use the move function to move the row to a different sheet, however no luck there - seems simple enough - any idea what I might be missing?

Thanks Jay

Andrée Starå

Hi Jay,

Strange!

What happens if you check the box manually?

Are there any clues in the Activity Log?

Try duplicating the workflow and see if that works. Did it?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

JayPedde

It works if i uncheck the box and save the sheet and then check the box and save again then the move works as expected. That action of course clears the formula out of the cell

It must have something to do with a formula creating the check mark. The automation process is likely looking for a cell value 1 or 0. I'm assuming reading the formula it sees neither and takes no action.

Thanks

j

Andrée Starå

Happy to help!

What happens if you use the formula without the ISERROR function? What's in the [Written number Ref]7 cell?