My company has a simple Google sheet used for staffing of our resources. In addition to cell formulas, there are some macro codes in the sheet for updating the time (weeks that are displayed), and also for sending out mails weekly to each person to ensure they have entered the correct information.
Today there is one sheet for entering data, and one sheet used to visualize the resource utilization.
I need to rearrange this spreadsheet so that the input and visualization sheet are merged by using collapse / expand functionality. In other words, by using a collapse / expand functionality, I would like the sheet to look like the output sheet when all resources are collapsed, and I want to be able to see and enter new projects by expanding each resource (in a similar way as we can do in the input sheet today)