Forum Discussion
Populating a finished document using tick boxes
whall316 I don't know if I understand the problem. Are you looking for automatic word wrapping? Here is the button on the Home Tab:
it is the button with the ab and the c below (i.e. wrapped to next line)
if you have spill error because more than 1 item is checked then add a Concatenate or TextJoin function around the FILTER:
=TEXTJOIN(" ",TRUE,FILTER('Workings page'!E13:E18,'Workings page'!D13:D18=TRUE,0))
whall316 I don't know if I understand the problem. Are you looking for automatic word wrapping? Here is the button on the Home Tab:
it is the button with the ab and the c below (i.e. wrapped to next line)
if you have spill error because more than 1 item is checked then add a Concatenate or TextJoin function around the FILTER:
=TEXTJOIN(" ",TRUE,FILTER('Workings page'!E13:E18,'Workings page'!D13:D18=TRUE,0))
- Hi, thanks for this - the textjoin work around will work fine once I rearrange the layout to suit.
Thanks for the input.
