How do you fix a missing reference?

Options

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

  • EEK
    EEK ✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!