Dec 07, 2021 08:40 PM
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!!
Dec 07, 2021 08:51 PM
Your last comma is in the wrong place, it should be after the AND()'s closing parenthesis
Dec 07, 2021 08:59 PM
Unfortunately I still receive an invalid error :confused: