Skip to main content
Asked a question 8 months ago

Hello guys, i have a question on formula. Say i have the following fields and i want to submit a diagnosis e.g if i check 3 places on a condition it automatically generates a diagnosis.How do I write the formula in clappia. I know its a COUNTIF question

Where am I?

In Clappia Community you can ask and answer questions and share your experience with others!

You can use below formula to count the number of checked options in the multi-selector block.

IF({hormone_pr_1}="", 0 , COUNTIF(SPLIT({hormone_pr_1}, ","))).

You can also retrieve the comma-separated values of the options checked in multi selector block using below formula.

SPLIT({hormone_pr_1}, ",")