Check Boxes / Collapsing

[dicko1]

I am trying to create a sheet to use for estimating. I have designed
the sheet so the various services we provide are labeled in an outline
format with check boxes next to the specific service and descriptions.
For Example:

Key:
CB = Check Box

Example:

TYPES OF SERVICES
CB 1.1 Service 1
CB 1.1.1 Sub-Service 1
CB 1.1.2 Sub-Service 2
CB 1.1.3 Sub-Service 3

CB 2.1 Service 2
CB 2.1.1 Sub-Service 1
CB 2.1.2 Sub-Service 2

DESCRIPTION OF SERVICES
CB 1.1 Service 1 - Description of service 1 is as follows.....
CB 1.1.1 Sub-Service 1 - Descrption of sub-service 1 is as
follows

ETC....

I am wondering if there is a way for me to hide all of the
descriptions of service until one of the check boxes is checked. So if
CB 1.1 Service 1 is check, then the description of 1.1 Service 1
appears below and the CB is checked next to it. The goal is for an
employee to check just the type of service above so that all 200 lines
of descriptions aren't confusing or overwhelming when they may not be
pertinent.

I appreciate an help you anyone can provide.
Thanks,
Ryan

 

[Dave Peterson]

I think it could be done, but it wouldn't be easy.

You'd have to use code to control the visibility of the children's lines. And
you'd have to know how deep each Sub-service could go:

1.1
1.1.1
1.1.1.1
1.1.1.1.1
1.1.1.1.2
1.1.1.2
1.1.2
1.1.2.1
1.1.2.2
1.1.3
1.2
....

And some sort of nicely named checkboxes (from the control toolbox toolbar) to
make sure that checking/unchecking a checkbox would touch the children and
parent checkboxes.

If all the children are checked, then the parent gets a solid check mark. If
some are checked and some are unchecked, then the parent gets a shaded
checkbox. And if none are checked, then the parent is changed to unchecked.

It would be a big task (I think).

========
Not as nice would be to use the Data|Outline feature. The users could expand
and contract when they want to see/hide things.

======
Ps. I did assume that the descriptions are single cells in the same row as the
checkbox/item name.

 

[dicko1]

I think it could be done, but it wouldn't be easy.

You'd have to use code to control the visibility of the children's lines. And
you'd have to know how deep each Sub-service could go:

1.1
  1.1.1
    1.1.1.1
      1.1.1.1.1
      1.1.1.1.2
    1.1.1.2
  1.1.2
    1.1.2.1
    1.1.2.2
  1.1.3
1.2
...

And some sort of nicely named checkboxes (from the control toolbox toolbar) to
make sure that checking/unchecking a checkbox would touch the children and
parent checkboxes.

If all the children are checked, then the parent gets a solid check mark. If
some are checked and some are unchecked, then the parent gets a shaded
checkbox.  And if none are checked, then the parent is changed to unchecked.

It would be a big task (I think).

========
Not as nice would be to use the Data|Outline feature.  The users could expand
and contract when they want to see/hide things.

======
Ps.  I did assume that the descriptions are single cells in the same row as the
checkbox/item name.










--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks Dave - Looks like I'll have to make a work around.

 

[Dave Peterson]

Maybe someone will have a better idea...

Thanks Dave - Looks like I'll have to make a work around.

 

[Stephen Bye]

Sounds like a job for
Data > Group and Outline...
(with Setting of summary-rows-above-detail so that they can be used as
headings)