Selecting data from a checkbox

[sdaddy]

Hi All,
I have summary sheet with cell G7 which is classification.

On another template that users will fill out, i have 4 classification values being: Mandatory, Core System, Priority, Discretionary which are selected by the use of a checkbox which they tick the correct classification type.

In cell G7 i need to check to see which classification type has been ticked and then display the classification type accordingly e.g. 1-Mandatory, 2-Core System, 3-Priority, 4-Discretionary. I have tried using something similar to:

=IF('01'!B21:D21=TRUE, "1-Mandatory", IF('01'!B22:D22=TRUE, "2-Core System", IF('01'!B23:D23=TRUE, "3-Priority", IF('01'!B24:D24=TRUE, "4-Discretionary"))))

...where sheet 01, B21:D21 are the cells that the checkbox is merged into.

Thanks. sdaddy.

[JBeaucaire]

Way, WAY easier ways of skinning this cat.

On your template, forgo the checkboxes for a combo box or an in-cell drop down list (through normal Data>Validation>List, then simply reflect the value chosen directly in your cell G7. Why work harder than necessary for this?

[martindwilson]

doesnt work like that ,you only need to ref the cell the check box is linked to(and you should only link to one cell anyway)

[sdaddy]

hi martindwilson, i cannot seem to be able to right click on the checkbox to assign it to a cell or look at the properties or anything. seems it could be locked. have u experienced anything like that before?

i am unsure how the checkbox was created i am just helping out in this area unfortunately...

[martindwilson]

its probably a control toolbox check box then
you need to go into design mode to edit it
make sure the control toolbox toolbar is visible(right click any toolbar at top and check the contol toolbox option)
look for the symbol on the left that looks like a blue triangle/sitting on a ruler
click that
right click checkbox
properties
and in the window that pops up you should see which cell if any its linked to.