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

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…