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.

Intake Formula:

Meta Formula:

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!