I want to count the number of select boxes, How can I Do?

[11183]

Hi there

I want to count the number of select boxes, How can I Do?

If MATH was checked, then Socore show 1
If MATH and HISTORY was checked, then Socore show 2
If MATH and HISTORY and ART was checked, then Socore show 3
If MATH and HISTORY and ART and MUSIC was checked, then Socore show 5

In Score’s column, I have tried↓

switchif(thisRow.[MATH].Not() Or thisRow.[HISTORY].Not() Or thisRow.[ART].Not() Or thisRow.[MUSIC].Not(),1,thisRow.[MATH].Not() And thisRow.[HISTORY].Not() And thisRow.[ART].Not() And thisRow.[MUSIC].Not(),5)

IF(Count(True(thisRow.[MATH],thisRow.[HISTORY],thisRow.[ART],thisRow.[MUSIC]))<4,Count(True(thisRow.[MATH],thisRow.[HISTORY],thisRow.[ART],thisRow.[MUSIC])),5)

But all of it was unwork…

If anyone has any experience in this regard, would be very interested to know your experience.

[Ander]

@11183

Here’s an approach you might be able to adapt to your use case:

Getting sum of more than 2 columns of a row in another column

@trader_umr Clever technique to set sliders as booleans. @Johg_Ananda Here’s another approach to throw in the mix: CountIf( List(thisRow.one,thisRow.two,thisRow.three,thisRow.four), CurrentValue=true )

[Pch]

That’s what I was going to suggest

List(thisRow.MATH,thisRow.HISTORY,thisRow.ART,thisRow.MUSIC).CountIf(CurrentValue=True())

[Federico_Stefanato]

Hi @11183,

You can add a column “Correct Answers” with the following formula:

List(thisRow.MATH,thisRow.HISTORY,thisRow.ART,thisRow.MUSIC).CountIf(CurrentValue)

(which is the same @Pch just posted, btw. Note that you can shortcut CurrentValue=True(), through CurrentValue alone, as it’s already a boolean)

And Score column will have:

If(thisRow.[Correct Answers]=4,5 ,thisRow.[Correct Answers])

[Pch]

Good catch @Federico_Stefanato .
I didn’t see the specific demand for 5 if everything was checked instead of 4

@Federico_Stefanato

(which is the same @Pch just posted, btw. Note that you can shortcut CurrentValue=True() , through CurrentValue alone, as it’s already a boolean)

I really need to write a post-it with this very good point and keep it on my screen !
Thanks for pointing this out !

[11183]

Its worked!!

Appreciate your helping!!

Thanks other user’s answer too!! Thankyou very much!!