Urgently need help with a formula!
I have a sheet used to maintain a list of projects, I will call it "Master Project List" and I have a second sheet that the team uses for scheduling which I will call "Scheduler". Team members use a form to enter their planned hours on a project into the Scheduler which includes the project number and the task name. Each project will have multiple rows on the scheduler sometimes the same task is also listed several times. I need to keep track of their billing against the actual. I need a cross-sheet formula that I can use on the "Master Project List" that will find all the projects with a specified project number and task then sum the billed for those rows. Each row on the master project list has several columns for budget due to each task having a set budget. Therefore, I need to search the scheduler sheet from the master project list for a match of the [project number]@row and the task@row then sum all those rows. I have attempted using sumifs but that didn't produce any result. I have tried a combination of index, match, collect, if/and, etc... For some reason I am unable to put something together. Maybe its because its friday... lol. If you can help, I would really appreciate it.
Business Systems Analyst ~ WithersRavenel
115 MacKenan Drive | Cary, NC 27511
Office: 919.469.3340 | Direct: 919.238.0436
Did I answer to your question or fix the problem? Please
Smartsheet Communitybyclicking Answer Accepted. It will make it easier for users to discover solutions and resolve problems.
Help Article Resources
Check out the Formula Handbook template!