% complete report for multiple projects
I am trying to build a report that shows % complete, by project, across multiple projects (eg, Proj 1 = 50%, Proj 2 = 75%, Proj 3 = 10%) in one report view/summary. To date all I have been able to do is task level / individual project level % complete
thanks!
Comments
-
Hi Mike,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Mike,
You might consider rolling up your sheet's task level % complete with hierarchy. Note that this will show a weighted % complete based on duration and subtask % complete. More info on this here: https://help.smartsheet.com/articles/765753-parent-rollup-functionality
Another idea is to create the formulas yourself either in a row at the top. That takes a little up front work but you'll get more customized results. Here's our functions list: https://help.smartsheet.com/functions
Either solution would allow you to generate a report with the parent rows or rows at the top so that you can gain more high-level % complete status.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives