Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 07, 2021 08:51 PM
Your last comma is in the wrong place, it should be after the AND()'s closing parenthesis
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 07, 2021 08:59 PM
Unfortunately I still receive an invalid error :confused: