I'm currently trying to figure out how to display predefined texts based on checkbox selections (multiple) in Google Sheets.
Example:
Checkbox 1 True
Checkbox 2
Checkbox 3 True
Predefined answers:
Answer 1
Answer 2
Answer 3
Result:
- Displaying the strings of Answer 1 Answer 3 in a textbox.
- If Checkbox 2 3 are checked, text of answer 2 3 should be shown inside a textbox.
Any idea how to make that happen?