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
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?
We ran into this same challenge and I built a solution that works well across multiple programs. Here's how we approached it:
Bonus: If you're using Control Center, you can template this process and apply it portfolio-wide easily.
There could be a very basic and simple answer to this, or a complicated one-I hope its simple!π We have around 50-100 projects at any given time and we need to track and report on various deliverables. I have set up Intake Form- Intake sheet-Portfolio tracker, as well as project plan for each project. The Intake form isβ¦
I have a project that is run in MS Project (Desktop) on clients SharePoint, which we also want to have in our Smartsheet account so that we can track the progress and allocated resources, without duplicating efforts on updating both. I have found this can be done via Data Shuttle (which supports desktop version of MS)β¦
Hello! Any tips and tricks to encourage the other departments (outside of Project Management/PPM) to use Smartsheet?
