Help with subtasks formula

[esantelmo]

Hey everyone
I need a formula that retrieves the average of field "Progress" of all subtasks that include the type "Milestone" ("Marco" in portuguese).
"Tipo" (type) is a multiselect field.

This is how far I've gotten (not working though):

(Status = "Concluída" ? 100 : (ISNOTEMPTY(Override) ? Override : (ISEMPTY(subtasks.tipo where any = ["Marco"]) ? 0 : (SUM(subtasks.tipo where any = ["Marco"]).Progresso / COUNT(subtasks.tipo where any = ["Marco"])) ) ))

As you can see there are other tests before the one I'm addressing but those work fine.

I believe I should be using a mix of "where" and "in" but those don't seem to work together.

Any help is appreciated!

[Erin-Cecele]

Hello @esantelmo! Is this inquiry meant for Quire, the digital publishing tool from Getty: https://quire.getty.edu/?

[esantelmo]

oh wow I guess it wasn't lol Em qui., 19 de dez. de 2024 às 14:08, Erin Cecele Dunigan < ***@***.***> escreveu:

…

Hello @esantelmo <https://github.com/esantelmo>! Is this inquiry meant for Quire, the digital publishing tool from Getty: https://quire.getty.edu/? — Reply to this email directly, view it on GitHub <#985 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATA65GQQI2B3JMSVKL3X3WL2GL4SDAVCNFSM6AAAAABT4XXEZ2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNRSGAYDGNA> . You are receiving this because you were mentioned.Message ID: ***@***.***>