IF OR Formulas
Hello, Trying to do a formula that looks at if a field says "Delivered" , however sometimes it could be "DELIVERED" the formula I have now will not pick up both. So can I do an IF OR statement. If ...
Forum Discussion
try this
If(Upper([Return Tracking Status])= "DELIVERED" and [Order Cancelled]=false and [Updates Needed]=false, "Complete", "Not Complete")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
If(Upper([Return Tracking Status])= "DELIVERED" and [Order Cancelled]=false and [Updates Needed]=false, "Complete", "Not Complete")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
