Table of contents in a large sheet; use of forms

Tomer

hi, 

I use one large sheet to manage many different legal tasks across my team (1,000 rows currently). The sheet is divided to many sub sections/categories, main tasks, sub tasks etc. Wanting to add a new main task to a category, the user needs to scroll down to find the right category which is time consuming.

Two questions please:

1. Can I create something like a table of contents in the beginning of the sheet, linked to the relevant category in the sheet? (by clicking on it the user to be taken to the relevant category in the sheet)
2. Can I create a form to be able to add a new main task to the relevant section/category? (was successful at only creating a form that adds a row to the end of the sheet, which then the user needs to cut and paste to the right section).

thnaks

Andrée Starå

Hi,

1. You could have a kind of ToC at the beginning of the sheet that shows which rows the different sections start at approximately and use the shortcut (jump to row) to get to that section. You could also use filters to get to different sections.
2. The form will always be placed on the top or bottom of the sheet and you move it to where you want it to be.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done