Avatar of Jim Schwetz
Jim Schwetz
 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.

=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,....

Open in new window


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 ....
Here is what the question looks like
Thanks in advance,
Jim
Microsoft SharePoint* Form CheckboxesInfoPath* ifsum

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Walter Curtis

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jim Schwetz

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

Thanks, seems like you have a good idea about how to do it now,
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes