How do you fix a missing reference?

Using the PMO template, I keep running into errors where my references are broke or incorrect. For example, on my Portfolio Metrics sheet, my references should be listed like below. Instead I only have Project ID. My formula is the same. How do I get back the missing references of Portfolio Summary Data and Portfolio Summary Header Row?


Answers

  • I found it! Right click on the cell > Manage References; +Create; Select Sheet; Sheet reference name; type in whatever you'll put in the {}; select the range; insert reference. Then when in the cell type whatever you put in the Sheet reference name in {}.