Can I use the number of owners in a formula?

[Rachael_Mon (Rachael Thomas)]

I’m looking to have my “owner” column register numerically as part of a formula so that I multiply our hours column with the number of people allocated to a task. Is this possible? If so, how?

[ioi_jason (Jason Sami [IOI/BPX])]

Hi Rachael,

This is possible. In the formula column you are able to count the number of owners assigned to a task, and then you can multiply this number by your hours column. Depending on your column names the formula would look something like:
{Owner#Count}*{Hours}

I hope this helps.

Jason

[Rachael_Mon (Rachael Thomas)]

Thanks so much! Works perfectly! Appreciate your help here Happy Monday(.com)