I am new to Smartsheet and making a dashboard. I want a widget to show as a pie chart illustrating how many :
1. "SRM"(child rows w/ purple check marked and bold text) there are [see screenshot below]
2. if it is "closed"(box checked) or not.
I know I need to make a separate metric sheet with a COUNTIFS formula referencing this sheet, but I don't know what to do next.
Thank you for your help