I have three columns that are dependent on one another.
The first column contains the dropdown list: Received, Awaiting, Not Required.
The second column consists of check boxes and the third column is % complete column.
Is it possible to make the check box cell for a particular row blank/empty given the choice in the first column is not required ?
The % complete column is dependent on the check box column.
So if the check box cell is blank/empty, the % complete cell must also be empty/blank.
Are there any suggestions as to how to go about with this ?