Forum Discussion
Solved
Populating a finished document using tick boxes
Hi I'm currently trying to create a document which allows people in the office to create a finished H&S document with existing text inputted using tickboxes. I've installed the tickboxes and the rel...
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))
Why not enter that text into a single cell? You can make the column wider and the row taller?
JKPieterse the only issue with this is that the finished document is already pretty much complete with all the column widths etc already set.