Copy to a sheet Automation - Referencing too many cells on the destination sheet

A_C

Hi,

I'm getting an error on a copy automation, please see below.

The workflow runs a daily copy of task (TSK) rows from 1.1-TSK - Demo - Strategy - Main Tracker Sheet to the 2.1-TSK - Demo - Strategy - Main Data Sheet, if the Update Status of the row is "Reported".

There are 3 sheets involved, and they are all linked using various formulae, as well as cell links.

1 - The Main Tracker

2 - The Main Data Sheet

3 - The Metrics Sheet

If you look at the stats below, the soln is not hitting any limits. However, the stats may be a red herring in this case, as I may well have put together the soln in a way that causes the problem. The odd thing is that it only started to do this on Monday of this week. I've been playing around with it on and off since then, trying different things, but to no avail. Raised a support ticket on Monday, but not heard anything back yet.

1.1-TSK - Demo - Strategy - Main Tracker - Sheet Stats

2.1-TSK - Demo - Strategy - Main Data Sheet - Sheet Stats

3.1-TSK - Demo - Strategy - Dashboard - Metrics - Sheet Stats

As ever, any help would be great.

Cheers,

A

A_C

Meant to add in the post.

I've tested this using a destination sheet with formulae in and a destination sheet version with no formulae in.  I get the same error.

A