jahmeanne✭

Thanks for your help Ryan! :)

Hey Ryan, I'm looking to get the status for all the child rows under "HRSS Prep & Planning". Right now I made a helper column and checked off all of the children rows pertaining to that category. I then setup a new sheet with the following formula: =COUNTIFS({HRSS Build - Project Plan Range 1}, 1, {HRSS Build - Project…

Hey Ryan, Thank you for your response! I'm not looking to build a report per say, but a pie chart that breaks down the status of everything under the "HRSS Prep & Planning" row. I reckon the check boxes will still help, I just need to figure out how to put it all together. If there is another way, please let me know. Thank…

Hey Jason, This is AWESOME! I'm going to try this right now. Thank you so much, I really appreciate you!

Ah, yes you're right. Thank you so much for your help. Appreciate you!

Thanks Paul! Do you know the best way to do a COUNTIF on a status that would exclude the child rows? I just want the blue parent rows counted.

Hi Paul, Thanks for reaching out! unfortunately, there are no check boxes associated with these sheets. Here's an example of what I'm looking for: I exported a user list directly from LucidChart. It displays everybody who has an account as well as who is licensed. I used myself as an example as I have both an account and a…

谢谢你这么多雷,从新加坡eciate the quick response!