I need to have the formula capture the project parent in parent row marked with a star in the project row column and the project in in progress - prioritized and in progress - not prioritized from the status column.
I am using the following formula but its coming back with a zero:
=COUNTIFS({Status}, "In Progress - Prioritized", {MH-Work Prioritization Log Parent Row}, 1, {Status}, "In Progress - Not Prioritized")