Best "infrastructure" columns for portfolio reporting

I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc.

I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date).

What other hidden columns do people include in their project level sheets to enable reporting and master portfolio roll up sheets?

Thank you

David

Find more posts tagged with

Templates

Sheets

Healthcare

Reports

Solution Center

Dashboards

Project Management

Comments

Shaine Greenwood

Hi David,

It depends on what you're wanting to specifically gather in your reports, but it sounds like you have most of your bases covered.

My only recommendation is to automate your hidden columns with formulas. You can create formulas that automatically check parent/children based on certain conditions. Check out the IF function here: https://help.smartsheet.com/function/if

david voight

Thanks Shaine...I already have all of the columns auto calculating for grandparent, parent, child, PofC and PandC. I also have an auto calc for milestones.

I am trying to think of any other metadata that might be beneficial in a use case where you have 100 projects and are rolling up to a portfolio view. Just trying to think of all possibilities before replicating the sheets numerous times.

Thank you for any other ideas you have.

Sign in to join the conversation!

Quick Links

Trending discussions

Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct
Report not showing all rows
I have a report that's sorted ascending by name but stops in the "T" section. When I sort it descending by name it shows the missing names after the "T" section at the top but then stops in the "A" section, but not all of them. There are 2217 rows and 19 columns in the report right now, is there a limit to how many rows I…
Create a new Grid outside of WorkSpace
I have not moved into the Workspace feature, I have my sheets all in normal historical folders. Now when I try and create a new Grid, it forces me into a workspace. How do I create a grid outside of a workspace?