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.