I’m trying to map some multiple choice outputs to predefined fields using IF functionality.
There are 4 choices for each question, if the person completes the form and answers ‘Experienced’ or ‘Highly Experienced’ then it’ll return the specified value within the IF formula.
The first issue I have come across is in my first screenshot below.
The first IF formula should correctly return ‘Elderly Care’ as the person has said they’re ‘Experienced’ or ‘Highly Experienced’. However, the second IF formula should return a blank as the person is neither of those. However it still outputs both the responses.
I’ve then tried to get around this by breaking up the formulas by creating an independent formula for each value (Experienced & Highly Experienced) - see below.
This does work as the second value (Supported Living) is no longer outputted. Although one issue with this is I then need to add around 15 more values with two separate formulas for each, which isn’t ideal.
However the second and bigger issue is that despite it returning the correct values seen in the screenshot below. Because there are two comma’s rather than one neither of the outputs get uploaded or mapped. The array only maps correctly if it outputs value separated by a single comma and then followed up the next value.
If there anything I’m missing here? I’ve tried quite a few different things such as putting formulas in more brackets etc.