Summary Sheet Not Connecting to Correct Column
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). In my summary sheet, the columns that should be looking at the text/number column for data are looking at the contact column instead and I'm unsure of how to fix this.
I had thought this was working correctly at first and I did move the column order at one point in the metadata sheet, so unsure if that caused the issue?
I tried removing the summary sheet from the blueprint and reconnecting but that did not work. Hoping to not create an entirely new summary sheet as I have other metrics sheets that have cross sheet references to this one, but may have to.
Ideas and recommendations welcome!
Answers
-
I'm sure it's an issue with your cross sheet reference. When you edit your formula, click on the range and you'll see an option to edit the reference. Then select the correct column.
-
@Michael Culley - Thank you, but the summary sheet through control center is set up using cell-links not cross sheet references. Updating 15 columns of cell links is not ideal and every time a new project is added to the summary sheet, it's linking to the wrong column.
-
@Kelly Pratt , did you find a solution to this issue? I have the same problem of Blueprint Summary date pulling from a text column when I want it to pull from a date column.
