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 {}.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!