Formula Based on Column Status

Platform discussions Special workflows & use cases
1

Hi,
I’m trying to make a formula in an item column like this, but I don’t know if the second part is possible.

{column 1}*({subitems#count) IF subitem status equals option 1)