IF, OR, AND Functions

Mylene Nafarrete

Looking to see if anyone can assist me with this formula. The formula works in Excel but not in Smartsheet, I'm getting an #incorrect argument set.

=IF(OR(AND([Tier Achieved(Target Validation)]@row = "Platinum", [2021 Tier Achieved]@row = "Silver")), AND([Tier Achieved(Target Validation)]@row = "Gold", [2021 Tier Achieved]@row = "Silver"), "Request Exception", "")

Thanks in advance.

Sameer Karkhanis

If you meant to check the OR of two ANDs then the paranthesis for the OR is in incorrect place; should be after the second AND like below,

=IF(OR(
	AND([Tier Achieved(Target Validation)]@row = "Platinum", [2021 Tier Achieved]@row = "Silver"), 
	AND([Tier Achieved(Target Validation)]@row = "Gold", [2021 Tier Achieved]@row = "Silver")
      ), 
      "Request Exception", 
      ""
)

Sameer Karkhanis

If you meant to check the OR of two ANDs then the paranthesis for the OR is in incorrect place; should be after the second AND like below,

=IF(OR(
	AND([Tier Achieved(Target Validation)]@row = "Platinum", [2021 Tier Achieved]@row = "Silver"), 
	AND([Tier Achieved(Target Validation)]@row = "Gold", [2021 Tier Achieved]@row = "Silver")
      ), 
      "Request Exception", 
      ""
)

Mylene Nafarrete

@Sameer Karkhanis - that worked! Thank you so much!