AnsweredAssumed Answered

Calculated value to validate multiple check boxes(All check boxes checked, Status = Complete)?

Question asked by eric.tamez on Mar 4, 2016
Latest reply on May 26, 2016 by kiric

I have a panel in a Nintex form that has multiple check boxes for tasks, like this:

[ ]Task 1

[ ]Task 2

[ ]Task 3

 

I want to have a calculate value field("Status") above this panel that validates whether all check boxes have been checked.  If all are checked, Status = "Complete".  If any are unchecked, Status = "In Progress".  I've done similar things in InfoPath, by setting the value to each check box to 1, then adding them together.  If sum = 3, Status = "Complete", if < 3, Status = "In Progress", but is there a better way to do this in Nintex Forms?  Perhaps if Task 1, Task 2, and Task 3 are all true, Status= "Complete", else Status = "In Progress"?  I'll end up having 12 different panels/sections with 6 tasks each that need to all roll up to the Status field, so I'm trying to make this as simple as possible.

 

I'm brand new to Nintex Forms, so any help would be greatly appreciated.  Also, I'm using the O365 version of Nintex Forms, if that makes a difference.

Outcomes