Can Wrike count the number of selected values in a multi-select custom field?

Question

Hi Wrike Community,

We are designing an intake scoring model and are trying to determine whether Wrike can automatically calculate a score based on the number of values selected in a multi-select custom field.

Example:

Custom Field: Strategic Objectives (multi-select)

Available values:

* Sales Eco-System
* Brand
* Excellence
* Customer Experience
* etc.

A requester might select:

* Sales Eco-System
* Brand

We would like Wrike to recognize that 2 values were selected and then automatically assign a score based on the count:

* 1 value selected = 10 points
* 2 values selected = 15 points
* 3+ values selected = 20 points

Questions:

* Can Wrike count the number of selected values in a multi-select custom field?
* Can a formula field reference that count?
* Can automations use the count as a condition?
* If not, what is the recommended approach for implementing this type of scoring model in Wrike?

We are integrating ServiceDesk Plus with Wrike, and the selected values will be passed into a multi-select custom field in Wrike.

Thanks!

Flora Sunjo · Answer

Oh. I never thought about using an AI agent. Let me look into this. Thank you, Pietro.

Pietro Poli · Answer

Hi @Flora Sunjo

As far as I know, this isn't possible natively. Formula fields and automations can't count the values selected in a multi-select field.

A couple of alternatives:

* Wrike Integrate: a recipe can count the selected values and write the score to a number field.
* AI agent: you could set up an agent that triggers when the field changes and assigns the points based on the number of options selected.

Flora Sunjo · Answer

That is exactly the conclusion we finally arrived at. Thank you, Sven.