Question

You need to view only a part of data at a time and hide the other

Answer 1

Answer:

There is a way to do this to an extent. What are the level iof the user that you want to block. If you lock the column at the top and hide the cells and viewer cant change the view. If the person that you are wanting to block is an admin then this wont work. If you want to have the numbers total to a parent row use the sum formula. =sum(children()) any items added under the partent will auto sum into the parent row.

I do recommend that you keep financial and schedule sperate. It is a best practice for us to do this. We have a fiinancial sheet and project sheet. We also have workspaces for the same.