User Profile
MNicolini
Copper Contributor
Joined Feb 21, 2022
User Widgets
Recent Discussions
Help with Nested IF AND Statement
Hello, My team and I have been working on logic for a report, but we cannot get it to work accurately across all criteria that we need it for. Here's the logic that we need to include: 1. If Column AP is "CPU", and Column AE is <= Column AD, return "Green" 2. If Column AP is "CPU," and Column AE is "", and Column AD is within 3 days of today, return "Yellow" 3. If Column AP is "CPU," and Column AE is "", and Column AD is < today, return "Red" 4. If Column AP is "CPU", and Column AE is > Column AD, return "Red" 5. If Column AP is not "CPU", and Column AE is <= Column AD, return "Green" 6. If Column AP is not "CPU", and Column AE is "", and Column AN is within 3 days of today, return "Yellow" 7. If Column AP is not "CPU", and Column AE is "", and Column AN is < today, return "Red" 8. If Column AP is not "CPU", and Column AE is >Column AD, return "Red" If anyone is able to assist, we would be very grateful!IF AND Function with Multiple Conditions
Hello, I'm trying to write an IF(AND formula that includes many aspects, but I'm getting lost in how many conditions there are. I need the report status to reflect different information based on 3 different columns: For example, if Column A is 22 or 23, it needs to show "Not Allocated", 33 or 44 should show "Allocated", and 66 or 69 should show "Shipped." But it also needs to pull in whether or not the shipment is late based on Column B. So, D2 should show "Late - Not Allocated" while D3 should show "Not Allocated." In addition, if there is an appointment date scheduled, it should also pull through that it's been appointed. So, D4 should show "Late - Allocated - Appointed." Please let me know if anyone can help. I've put together some formulas for pieces of it, but I can't seem to get it all to work together.AND Formula not Working
Hello, I am working on a Gantt chart style calendar which will show when a promotion is running. I am using an AND function to pull this information through via Conditional Formatting. On a small, test data set, it is working fine; however, when I transfer the formula to my actual data set of several thousand lines, it is not working. TEST SET: The formula is entered as =AND(L$16>=$H17, L$16<=$I17) but the formula itself seems to change in the Conditional Formatter and does not pull through as it should: Is anyone able to assist?
