Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculating cost of multiple projects in one sheet
I would like to calculate the cost and hours of multiple projects in one sheet, I would like to see how the cost and the hours of the project are increasing and decreasing in the various phases of the projects. I would also like to put this information on my dashboard and report it to leadership as a visual report.
Comments
-
Hi,
You can try building reports
https://www.youtube.com/watch?v=_HhlCxxo7Lk&t=195s
And link content from other sheets into one sheet
https://www.youtube.com/watch?v=drX1cfJV6RE
Good luck.
-
Nikki
This can be achieved by careful workflow design and by using a combination of each Project Sheet having a summary Dashboard of Standard KPIs reflecting progress in that sheet, which are then linked to the Master Portfolio sheet. Then use Reports to get the work done, or look across multipe sheets eg for a worker who is onvolved in many projects, they get the work done through their (Report) to do list. A Different criteria Report for senior management and a Smartsheetlabs Graph to show at the board Meeting.
If that is not detailed enough, we have developed a workflow using Appsheet with Smartsheet which enables one task to be contributed to, by multiple workers over say a couple of weeks eg a bulding site, with only the sum total appearing in the project sheets. This workflow also includes the use of a Base line vs Actual Gant View at the various levels.
For anyone seeking to explore the benefits of that more complex workflow, we offer a Free initial consultation and Demonstration? To be clear, there are costs involved in this solution if that is an issue.
Hope that helps and let us know how you get on Nikki.
RichardR
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 136 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 485 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives