Use case

Return the number of child issues in statuses with the status category "To Do" or "In Progress".

Expression

Create and configure a Smart field using this expression in General parsing mode:

%{count(issuesFromJQL("statusCategory in ('To Do','In Progress') and parent = " + %{issue.key}))} 

Used parser functions