Formula help for project roll up

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!