Portfolio Metrics and Dashboards
Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake sheet) creates my weekly status report template.
Any reason you guys can think of that would make all of my formulas freak out by changing the reference to the meta data sheet? Seems like it just does not want to acknowledge it's existence. Apologies for the muddled brain, but here's an example:
When the formula references the Intake Sheet, it results in a number, but it's wrong. When I try to make the formula reference the Metadata, I get unparseable.
Help Article Resources
Check out the Formula Handbook template!