Help

Trouble using nested IF formula with AND function

Topic Labels: Formulas
1273 2
cancel
Showing results for 
Search instead for 
Did you mean: 
notifications_B
4 - Data Explorer
4 - Data Explorer

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!!

2 Replies 2

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

Unfortunately I still receive an invalid error :confused: