And/Or Formulas


Hi All,

Need help with an IF statement using AND/ OR. I need to be able to check the box whether the vendor change/disc change/vendor catalog columns are blank or some of them have a value (ex: Vendor Change) in it and I keep getting an error.

Here is my formula, any suggestions.

=IF(AND([Vendor Change]@row = "Vendor Change", [DISC CHANGE]@row = "Discontinuation", [Vendor Catalog]@row = "Vendor Catalog"), 1, IF(OR([Vendor Change]@row, "", [DISC CHANGE]@row, "", [Vendor Catalog]@row, ""), 1, 0)))



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!