Trouble using nested IF formula with AND function

I keep receiving an invalid error when trying write this formula:

IF({Close ID} != “”, "imported”, IF(AND({Commercial?} = “yes”, {Close ID} = “”), "ready to import”))

field 1 is a single line text field and field 2 is a single select field. Both If statements work when using them separately.

Any help would be much appreciated!!

Page 1 / 1

Your last comma is in the wrong place, it should be after the AND()'s closing parenthesis

Unfortunately I still receive an invalid error

Sign up