Error counting Children Completed tasks referring another sheet

Angela Formiga

Hello,

I have a Summary sheet to have all counts of my sheets.

I am trying to use this function: =COUNTIF(CHILDREN({Product Release Roadmap Intervalo 3}); "Complete") to have the count of the completed children tasks in anothet sheet named "Product Release Roadmap"

but it is returning "Unsupported crossheet formula"

Can you help me?

Thanks

Andrée Starå

Hi @Angela Formiga

Unfortunately, it's not possible to use the CHILDREN function in a cross-sheet formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, would it work if you numbered the children rows and use that as criteria instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Angela Formiga

@Andrée Starå

thank you for the answer.

how can I number the children rows? any easy manner?

Thank you