Constraint if statement with two select multiple questions

[BradenWarns]

Hello,

I am having trouble with creating an IF statement with two select multiple questions in the constraint field.

Here is what I need to happen:

Here is what I have for the if statement:

if(selected(${extrarequest}, 'Extra_96g_Garbage'), 'One_time_fee' and 'Monthly_fee',
if(selected(${extrarequest}, 'Extra_96g_Recycle'), 'No_fee',
if(selected(${extrarequest}, 'Extra_96g_Garbage') and selected(${extrarequest}, 'Extra_96g_Recycle'), 'One_time_fee' and 'Monthly_fee' and 'No_fee',
'Remove_Recycle')))

I don't get any errors however, the constraint is not wrong correctly. I am sure I am missing something.

Any help would be greatly appreciated! @JamesTedrick    

[Katherine_Clark]

So, I'm not completely sure without testing it myself, but I believe select_multiple questions store the answer as a string, separated by commas. So instead of 'One_time_fee' and 'Monthly_fee', it would be 'One_time_fee, Monthly_fee'.

[BradenWarns]

I tried your suggestion. I did not get an error, but it still is not functioning correctly. Thanks.

[Katherine_Clark]

Would you be able to share your XLS form? 

[BradenWarns · Accepted solution]

I decided to change this section. I broke up the second multiple questions into single questions. Then used a simple selected function in the relevant field. Much easier to work with. Thanks for your help @Katherine_Clark

[Katherine_Clark]

Happy to hear you found a workaround!