checkbox if statement based on date and multiple drop down options
I'm trying to set up a formula that will check an "At Risk" flag based on a date and several drop down options. Example for row 7 : If the [Ship Date Estimated]7 is less than Today and the [Status]7 does not equal "Shipped" then check the flag or if the [Delivery Date Estimate] is less than today and the Status does not equal "Received" or "Online Order" or "Delivered" then check the flag.
But I haven't found a way to combine And statements and Or statements into the same formula but couldn't figure out how to do it with the online references I found. Any help is appreciated.
Thanks for any help.
Help Article Resources
Check out the Formula Handbook template!