So I have a SharePoint calculated list field already which adds up how many of the three Yes/No checkbox fields are checked using the formula:
=SUM(Opportunity+0,[Decision Maker]+0,[Willing to Engage]+0)
This works great when the column is displayed in a list view, but I wanted this list field & its value to also display on the Nintex form. However, when I try to add the calculated list field to the form, there is no option to display a calculated field type from the list onto the Nintex form. If there is a way to do this please let me know and that will solve my issue.
In the absence of that option, I've now tried to add a Nintex calculation control to my form to do the same calculation AND display on the form. Now my problem is I can't get the field to dynamically recalculate when the fields are toggled on/off while in the edit mode. It DOES recalculate when I save the form & reopen, but not when I'm in the form editing. I have all of the Nintex form calculated field settings set to Recalculate on all form types.
Here's my formula...any thoughts on how to trigger the calculated field to recalculate when I toggle the checkboxes?