Right away I see a few problems…
- You’re closing the first
AND() function and then immediately adding another one with no comma separating them. The lack of a comma is itself a problem, but if all conditions are to be counted—including the single condition in the second AND() function, they must all be part of the first AND() function. In other words, there’s no need for the second one.
- You have an extra quote and comma before your final string
As a side note, you can simplify your last two conditions (the ones where you’re currently comparing fields against BLANK(). You can use syntax similar to the first two fields and just use the field names themselves. For the final one where you want to see if it is blank, you can wrap the field reference in the NOT() function.
Addressing all of these items—and splitting it across multiple lines for easier reading—gives me this:
IF(
AND(
{est_filing_date_range_start},
{est_filing_date_range_end},
{actual_or_estimated},
NOT({review_type})
),
"🛑 ERROR...review_type CANNOT BE BLANK when est_filing_date_range_start, est_filing_date_range_end, actual_or_estimated fields are populated",
"✅ GOOD"
)
