Forum Discussion
how to show what projects each person is working on
Hi we have a project spreadsheet, which all the projects we have going on in our department on it. We also want to add a workload tab which shows how many hours people are working on each specific pr...
Another method that occurs to me is to use the named range capability. A cell could be named "Emily_whatever" and then you can make a reference to it on your dashboard by just entering =Emily_whatever as the formula.
To name a range, go to Insert.....Name....Define
So much depends on the layouts of your sheets, the flexibility you expect, and so on. As I asked earlier, if you can upload a sample, devoid of confidential and personal info, that would be a great help in helping you.