Intermittent circular reference from cell link
I have a series of linked sheets based on the PMO templates provided by Smartsheet.
There are 3 sheet types.
Project Intake Sheet - there is one of these.
Project Metadata - as many as required
Project Plan - as many as required
The Project Intake Sheet supplies data to the Project Metadata sheet via an index formula. Key metadata is input onto the intake sheet, and an autonumber generated. The Project Metadata sheet has the autonumber input and the index formula pulls through the metadata. There are then a series of columns which are joined back to the Intake sheet via a manual cell link. It's some of these I have the issue with. They take data from the project plan via a cell reference, and then these cells are subsequently referenced by the intake sheet.
I added 2 more columns to this which link to cells on the project plan. Those cells contain formulae.
If I link to these cells from the intake sheet, I get a circular reference
If I remove the formulae, create the link, then put the formulae back, I don't get a circular reference error and it works fine.
So what's going on? It clearly isn't consistent. Bug?
Help Article Resources
Check out the Formula Handbook template!