Formula help for project roll up
Hello,
I'm struggling to come up with the correct formula to use. I have a sheet with several different project numbers and also use the same project numbers. There is a planned, in progress, and completed status. There are parent and children rows with each project #. I'm only concerned with coming up with the sum of each status one one project # that is used 35 times across the same sheet. I created a report but since there are children it's only counting the project status as a whole instead of by the status type. I then decided to create a separate sheet to use a formula to roll up only that project # by incorporating the status, but I'm struggling on what formula to use. I would like to have this show in the report already built and also on a graphy in a dashboard. Any advice would be appreciated!
Example for the columns:
Thank you!
Answers
-
Are you able to provide the expected output for the above screenshot? I'm not sure I follow exactly what you are wanting to accomplish.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!