Dashboard creation from Portfolio Metrics sheet
I am trying to build a dashboard of metrics and charts, I discovered that it is easier using data from sheets than from report and summary reports. I came across portfolio metrics as source sheet for dashboard - I am thinking it was created by linking cells from different sheets.
How can I go about creating formula to auto populate portfolio metrics sheet from my project sheets so it can serve as a source data for my dashboard?
Please help me.
Below is what I designed as portfolio metrics sheet but don't know what next.