I am trying to turn a traffic light green based on the following criteria:

EMV Ready? = Yes

Payment Platform from Dispensers can only include Gilbarco FlexPay II and Gilbarco FlexPay IV.

Trying the following and getting an #INCORRECT ARGUMENT SET

=IF(AND([EMV Ready?]@row = "Yes", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay IV", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay II", "Green", "Red"))

Have tried using IF(AND(OR and didn't have much luck

Any help would be appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!