count() function in formulas

Hi, there!

In a product discovery board I would like a custom field called Value where the value is based on a formula. This formula takes it input from a selection of other number fields, such as Effort, Customer value, Company value, Size etc. But, we also have a custom field called “Reporter”, which is a multiselect. Values here could be Team, Company, Customer A, Customer B etc. I would like to use the number of reporters in our Value formula. The more reporters the higher the calculated value of the feature, in combination with effort, size, weight etc.

So, something like count(Reporter) * Effort * Size = Value

Note: Not a solution but marked as such to elevate a key reply

Don’t forget to click the title to scroll to the top and vote by clicking the Vote button (like I did); that’s the quickest and most effective way to express your support for a request.

You may also want to vote for this:

And, note the workaround offered there. You could do something similar as a workaround here with rules and extra number-type custom field(s) to set that/those, then use those in your formula. That would get this up and running today, albeit with extra effort.

Thanks,

Larry