2

I would like to be able to tick or untick a checkbox in iWork Numbers based on certain parameters.

The spreadsheet is a list of projects (Column C), each composed of several tasks (column D). Column B is a completion date that gets filled in by the user when a task is completed. Column A contains checkboxes.

I would like to be able to automatically check the box in column A when a date is entered into column B. Further, I would like to automatically check the box for the project once all the boxes are checked for the encompassed tasks.

A sample code for task completion would be: IF(B2<>"",TRUE,FALSE).
Sample for project completion would be: IF(COUNTIF(C,C2)=COUNTIFS(C,C2,B,"<>"&""),TRUE,FALSE).

What I'm hoping to accomplish is to convert the TRUE or FALSE result of the formula into a ticked or unticked checkbox.

0

Unfortunately, cells formatted with as "Checkbox" type will not accept a formula in the current version of Numbers. (version 4.3 as of this posting)

One workaround is to use a formula such as this: =IF(ISBLANK(DateCell),"","✓" in the cell you wish to have the tick mark. Of course, one can get much more creative than this, but it is a start.

The 'Check Mark', as it is called in the system can be found in the Character Viewer.


Formula for checkmark

Live Demo

Character Viewer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .