User Profile
bperry1792
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: How to Create a Formula Based on Multiple Conditions
mathetes wow, thank you so much! XLOOKUP proved to be just what I needed. By using the table I created thanks to mtarler 's idea, I was able to use that function to calculate how many days were added to the start date based on a certain phase, and then was able to put a simple formula together to to add "x" amount of workdays to get my end date. While we're here though... Do either of you have experience with VBA's and Macros? I'm hoping to be able to set up automatic emails to notify users when a cell has been updated that is relevant to them. I did some research and found a ton of code that is based on numerical values, but I can't seem to find any that uses text values. For example, if the salesperson is "Keith Brown" and the "Current Department" phase turns "Sales_Design", I want him to be notified of that. And likewise, if it goes into a department that is not sales related (like Estimating), then I'd like the Estimating manager to be notified when the "Current Department" phase is updated to "Estimating". Thanks again for taking time out of your day to work with this!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 to have the end date auto-populate based on the Job Level and the Department Phase. For example, if the Job Level is Level 1, and the Department Phase shows "Design Revisions 1" and the average lead time for those revisions is a week (workdays), then I want to be able to put the Start Date in and have the end date automatically pop up 5 days after the start date. I currently have 4 different Job Levels, 7 different Current Departments, and 51 different Department Phases (but those are broken up by Department) and I'd need to put a certain length of time for each of those. Does anyone have any suggestions or formulas that I can use? Thanks in advance!
