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
Microsoft SharePoint* Form CheckboxesInfoPath* ifsum
I think I will use some hidden columns, and try to get something to work that way. If I do, I will share it.