I have a question (Questions::Order = 1) in a survey (_pk_SurveyID = 6) that uses a checkbox field with the values:
I wanted to create 4 fields that each contain "yes" if one of the 4 corresponding checkboxes is checked.
I tried this calculation for the Attending name field
If (Surveys::_pk_SurveyID = 6 and Questions::Order = 1 and Response = "Attending name"; "Yes" )
but it doesn't work. What am I doing wrong? Is there a better way to do this?