In a multiple option cell counting how many options selected.

Stevey C

In a form linked to a request tracker I have dropdown multiselects, one of these has 30 of which and number may be required.

I would like to calculate the number of tasks needed for use in a complexity calculation used when determining whether a template should be used or into a dashboard for employee workload..

Stevey C

Hi, my apologies I resolved it very simply using COUNTM and forgot to update.

KPH

Hi @Stevey C Could you post an image of your sheet (removing anything that should not be publicly visible) and an example of the calculation you are trying to do? That would make it easier to understand the problem.

Stevey C

Hi, my apologies I resolved it very simply using COUNTM and forgot to update.