Hey all,
I would like to create a table where all the rows got checkboxes and every time I'm adding a new line the checkboxes are automatically added.
Something like:
| Employee | col A | Col B | Col C |
| Jhon | [ ] | [ ] | [x] |
| Bob | [ ] | [x] | [x] |
- adding new line will result in
| | [ ] | [ ] | [ ] |
Is there a way getting it without buying add-ons?
I have a similar requirement: I'd like to be able to add a column to a large existing table containing a tick-box for each row in the table so I can use it as a checklist.
I used the work-around above: Inserting the "task list" maco into a cell. Assuming you only want the checkbox, without a label, simply use a period as the only character, and use the text tool to change the font color to white (or whatever background color your cell has).
You can now copy / paste that checkbox cell as much as you like.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
works the same with a space character
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To follow up on this, it seems to work if you have text after the check box, but if you're just using the checkbox in a cell without any text (a pretty normal thing when representing tasks as a matrix, just like OP intended), it will not copy the checkbox.
See my screenshot for a demo. The upper row in each pair is the pasted row.
Update: I found this ticket for the issue, which they have reopened at my request
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can just type [] and then hit the Delete key. The checkbox will be created, and the auto-generated label will be deleted. Or, you can update the verbiage as your own label.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've worked around this problem by using emojis 😐
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, this doesn't help, because when you copy a table row or column containing a checkbox (task macro), it doesn't copy the checkbox. The cells on the resulting row/column are empty
update: this is true if you don't add text after the box
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can create a table and add the "task list" macro in each cell.
Then when you want to add a new line, just copy one of the line and paste it. With the action buttons in the action bar above it's quickly done.
You will then only need to uncheck the checked boxes (or if you prefer, keep the first line with unchecked boxes for later copy paste but it is not that good visually).
I don't have idea for more automation without add-on.
Does it help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.