Re: Field formula of items not selected in multi select
I researched older posts and found similar topics such as this, but nothing solved that answers this particular question....
I want to create a field with a formula that lists any items not selected. An applicant has to acknowledge acceptance of the "rules", and we need a list of rules they did not accept.
Is this an easy do?
The sample form is shown below. The ideal answer is that the 3rd item would show up in the new field with the formula.
Hi,
The formula is quite simple despite having much text, so I would create it using another formula. Otherwise, if you accidentally add extra quote, it will be hard to find a mistake in formula.
In some temporary or test table make a long text field 'Question' , put your questions one by one.
add formula field at right:
SUBSTITUTE("IF({X},'','X'&'\\n')&","X",Question)
Now collect all the lines you need and use it as a new formula. I mean copy-paste them all to the formula text.
Don't forget to remove the last ampersand.
That's it.
Please be aware - after you create a field with this formula, and work with it, later, if you change the name of any field mentioned in it, it will be automatically changed in {Question A} part (for example), where it represents a field name, but it will not be changed in a part 'Question A' - where it is just a text value.
