Welcome!

Portfolio Level Week-to-Week Changes

Nikki G

Hello!

Is there a report and/or a way to show week-to-week changes for all projects across the entire portfolio?

Thank you,

Nikki

Find more posts tagged with

Comments

Antonie B

Hi @Nikki G ,

There is not really an out-of-the-box function, what I have done in the past is to create a sheet in the Project Toolkit (What I call the folder that houses all the templates) with a row that captures the metrics you want to capture week over week.

I then create a copy row automation (https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet) to send this over weekly, creating a record/audit log of sorts. This can then be pulled into a report, where you can then report or chart this data. You will need to add a date column to the metadata sheet to capture the date. I use "Record a Date" to record today's date daily on the sheet. (https://help.smartsheet.com/articles/2481986-work-record-date-action)

Hope this helps?

HockinsonJohn

Hi @Nikki G ,

We ran into this same challenge and I built a solution that works well across multiple programs. Here's how we approached it:

Snapshot Sheet Method – I created a weekly snapshot sheet that logs key portfolio metrics (like % Complete, At-Risk Projects, Delays, etc.) every Friday using a helper workflow and a simple "snapshot row" per project.
Automation – Smartsheet automation copies data into the snapshot sheet at a set time weekly, so it’s hands-off once built.
Portfolio Rollup Dashboard – We pull the data into a dashboard showing week-over-week changes using chart widgets and summary reports for visual tracking.

Bonus: If you're using Control Center, you can template this process and apply it portfolio-wide easily.

Sign in to join the conversation!

Quick Links

Trending discussions

How Do You Capture and Automate Meeting Notes in Smartsheet?
What are your best practices for capturing project meeting notes directly in Smartsheet and automating how those notes and action items flow into RAID logs or other project artifacts? Today, our team takes notes in OneNote, emails them out, and then PMs manually update the RAID log and other sheets in our project suite.…
Stacked Bar Chart to display Count AND percentage?
I am tracking orders in 3 statuses (Expected —aka my grand total; Rcvd; and Completed). I have a stacked bar showing the count of each, and this is the ideal visual i'd like, but i was hoping to also reflect the % of completed against Rcvd and Expected, and the % of Rcvd against expected. Is this possible?
Using Smartsheet for "Severity 1" project issue updates
Hello all: Brainstorming ideas here. Instead of sending multiple emails out to stakeholders throughout the day ('Reply all, Reply all, Reply all'), does anyone have any suggestions on how to use SS to update stakeholders regularly when there is a serious technical issue on a project? Keep in mind that I would only want the…