Hi Smartsheet Community,
I need a formula which will allow me to look up the number of non-blank rows under a parent row from another sheet and return the value.
As an example I've attached a screenshot of my reference sheet where I am trying to count the non-blank rows under the parent row "Over 50%", some of the information has been blocked out for confidentiality. I will also need to repeat this for the other categories on the sheet such as "Confirmed" etc.
I didn't want to define the range too specifically (for example just use the COUNT function and only reference the exact rows under the parent row) as I need the owner of the reference sheet to be able to insert and delete rows freely under each category without it affecting the formula or a row accidentally being added outside of the reference range.
I've tried using a combination of COUNT / COUNTIF with PARENT / CHILDREN but don't seem to be getting the result I need.
Please help?
Thanks!
Katy