Forum Discussion
How to Create a Formula Based on Multiple Conditions
Pictures are good, but an actual spreadsheet--so long as it doesn't contain any proprietary information--would be many times better. Otherwise you're asking us to copy yours (and possibly, therefore, be missing some things that are off-screen)......
I think your request is clear enough, but it would just be a lot easier to help you through seeing and working with the spreadsheet that you depict in that image.
mathetes Thanks for your reply! Attached is a smaller version of my spreadsheet (the original was too big to attach) - let me know if I can provide anything else.
bperry1792 so I tweaked your reference sheet to have Phase and Level making a table. Fill in the estimated times into that table then you can use that table to do a lookup to fill in the estimated end time:
If those aren't "hard"/known times but you have a large file of past jobs and such you could do the same thing but fill in the table by using formula (probably a couple sumifs()/countif() or a sumproduct() formula)
mtarler Thank you so much! The table idea proved to very helpful and that is exactly what I did. I had to create a new sheet for the 50+ different phases I had, but it worked wonderfully for the data that I needed to reference.
