Forum Discussion
How to Create a Formula Based on Multiple Conditions
Hello, I apologize as I am probably using the incorrect terms to say this but I'm going to try the best I can. I have a spreadsheet that currently looks like this: What I need to do is t...
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)