Why is this happening all of sudden?
I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked.
As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets has been changed.
Recently, the workflow has become invalid and will not run.
I receive the following error message in the workflow " There are too many cells referenced by formulas in this sheet. Please reduce the number of cells referenced by formulas."
When I attempt bypass the workflow (deactivate workflow) and then manually "Move to Another Sheet" or "Copy to Another Sheet" I get the same error message.
I appreciate any and all suggestions. I am probably overlooking something quite basic...but, this has been functioning perfectly for so long and now that it has suddenly given up the ghost has got me scratching my head...plus...it is Monday ;)