Table of contents in a large sheet; use of forms
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:
- 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)
- 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).