asked on # SharePoint calculations based on check boxes.

SharePoint column, type=calculation, formula to assign values based on a column with check boxes.

While in the formula box, I do not see the column name to be inserted. Is that because the column has checkboxes? So I can add the column name manually, but how do I add the column name & checkbox name.

All I am trying to do is get a sum based on how many checkboxes are checked. one of the check boxes is worth 9 points, the others are worth 3 points. The column name is Risk. I was trying to have it max out at 9 points. so the first if was going to sum just the first checkbox if true, or sum the other 3 for a total of 0-9.

Using info-path with a SharePoint list. It does not allow you to set a name to each checkbox. Looks like it defaults to "value"?

So i tried using the title of the check box, and tried using checkbox1 ....

Thanks in advance,

Jim

While in the formula box, I do not see the column name to be inserted. Is that because the column has checkboxes? So I can add the column name manually, but how do I add the column name & checkbox name.

All I am trying to do is get a sum based on how many checkboxes are checked. one of the check boxes is worth 9 points, the others are worth 3 points. The column name is Risk. I was trying to have it max out at 9 points. so the first if was going to sum just the first checkbox if true, or sum the other 3 for a total of 0-9.

```
=if(checkbox1=true,9,sum(if(checkbox2=true,3,0),if(checkbox3=true,3,0),if(checkbox4=true,3,0)))
or
=if([checkbox1],9,if([checkbox2,3,if(checkbox3,3,0)),0)
or
=sumif([checkbox1],9,sumif([checkbox2],3,....
```

Using info-path with a SharePoint list. It does not allow you to set a name to each checkbox. Looks like it defaults to "value"?

So i tried using the title of the check box, and tried using checkbox1 ....

Thanks in advance,

Jim

Microsoft SharePoint* Form CheckboxesInfoPath* ifsum

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Thanks, seems like you have a good idea about how to do it now,

I think I will use some hidden columns, and try to get something to work that way. If I do, I will share it.